Hi Leslie,
In addition to @AndyBentley’s comment, I have the following advice:
We have used the Boolian boxes in the Collection Object table to capture that data but would now like to transfer the data from those Boolian boxes to Boolian boxes in the Collection Object Attribute table.
If you are doing behind-the-scenes work on the database, you would need to use SQL commands to create new Collection Object Attribute records (if they do not exist already), link them with the Collection Objects, and then you could use an UPDATE statement to set a boolean field in that table to TRUE when the Collection Object boolean field is TRUE. At that point, you could unset the boolean field in the Collection Object table and the process would be complete.
This is a bit of a complicated maneuver, especially if there are not existing CoA records associated with your CO records.
(Attr perhaps?)
However, when my IT person looks in the Attr table, it has nothing in it.
The CollectionObjectAttrs relationship and table are not meant to be used at this time. You can however use the CollectionObjectAttribute relationship and table!