Reassign Record ID number based on Associated Record Name in Another Table
I have two tables in my database: Objects and Maintenance Tickets. The Objects table has information about the object, the Maintenance ticket table has information about a maintenance event that is needed for that object. They are linked by the primary key of ObjectID, and each maintenance ticket also has a MaintenanceTicket ID.
After a maintenance ticket record has been created, I need a simple way to reassign that ticket to a different ObjectID. The difficult part is that I would like a button titled "Reassign Ticket to Different Object" that would then bring up a drop down menu of object names but would replace the ObjectID when selected, so that all of the associated Object info on that maintenance ticket is also updated.
In summary, How do I create a button that will replace the ObjectID field data in the maintenance ticket view, but allow me to select the replacement data from a list of all object names in my database (i.e. not a list of the Object IDs)?