I have a question about working with the table control on a form. The attached database shows my setup. On the ClassAssignment form I have listboxes that let me populate the fields in the tblMapClassEntryExbtr table. I’d like to auto-populate the Exhibitor field with a default entry from the tblEntries table when an item is selected from the Entry listbox pulldown. Then the default Exhibitor can be overridden with the Exhibitor listbox pulldown if desired. Is there a relation that would accomplish this? Or does it require Macro support? Or am I totally going down the wrong track?
MinDemo.odb (44.9 KB)