Here’s the idea:
I want to automatically fill a record’s Primary Field in TableA with a title that is a combination of the “Guest Name” from the same table AND the “Show Code” from TableB, a different table in the same base. However, the “Show Code” from TableB should be automatically determined by the “Show Name” also in TableB that is referenced in TableA’s linked field.
I feel like there most be an If, and, then something or other in there.
SHOW NAME - “Command of Desserts”
SHOW CODE - “COD”
PRIMARY FIELD - “COD: Harry Morgan”
SHOW NAME - Linked to TableB’s Show Name
Please help me clarify my convoluted question and thanks for ignoring my ignorance .