Here is a SQL query that inserts a status flag for all objects in an Object Package. INSERT INTO StatusFlags (ObjectID, FlagID, OnOff, LoginID, EnteredDate, TableID) SELECT ObjectID, [the FlagID you want], 1, 'UserLogon', GetDate(), 108 From StatusFlags WHERE ObjectID IN (select ID FROM PackageList INNER JOIN Packages ON PackageList.PackageID = Packages.PackageID WHERE Packages.Name = '[Your Package Name]) Dick Richard Grant Executive Director 3214 College Avenue Berkeley, CA 94705 <mailto:[log in to unmask]> [log in to unmask] 510.428.1400 ext 4 510.459.4556 mobile <https://www.instagram.com/diebenkornfoundation/> Instagram | <https://twitter.com/diebenkorn_fnd> Twitter <http://www.diebenkorn.org/> From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Clancy, Megan M - (meganclancy) Sent: Monday, June 26, 2017 10:20 AM To: [log in to unmask] Subject: Adding status flags to an object selection Hi all, We are currently undergoing a big project that will be using status flags. Currently we tend to use flags object by object, but this project will mean flagging whole accession groups. Is there a way to apply a status flag to the entire object selection? Thanks, Megan To unsubscribe, send an email to [log in to unmask] <mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.