My boss created a few custom tabs and tested them quite successfully in the Test database for the last several days. After a live to test copy, his screens are gone. The appropriate (or so we believe) data in the TR_CUSTOM_TAB tables has been replaced as well as the underlying tables having been rebuilt. Any ideas?
Also, does the Object ID field have anything to do with this? It's a strange column that doesn't seem to serve a purpose, but we're sure it does. Any light to be shed on that would be great. I'm sure it's in the documentation, but this time it's my boss who didn't read it first. :)
Thanks as always, Tessiturians.
Bonus Trivia Extraordinary Event: In Bermuda, two brothers were killed precisely one year apart at the age of seventeen by the same taxi driver carrying the same passenger on the same street. The two boys had each been riding the same moped...
The Object ID field relates to T_APP_OBJECTS.object_id (Security Objects table) and is only used for custom tabs in the Constituent window (custom tab). It allows the association of custom security objects in the Security application beyond the standard 6 custom screens, which then can be used in the Security application to grant specific Add/Delete/Edit/View rights for each user group.
If you are indeed referring to custom tabs in the Constituent window, make sure that there is at least a number from 81-86 in there (which corresponds to the standard security objects) where where 81 is Const Custom RB 1 and 86 is Const Custom RB 6. Custom Tabs beyond the standard 6 in the Constituent window should begin with an object ID greater than 10,000 (which will correspond to a new row in T_APP_OBJECTS for the custom tab for the same object_id).
Hope that clarifies, rather than muddles.
-Ryan