Dropdown box to select a record in a 1 to N relationship?
I have two tables with a 1 to N relationship.
In my layout of table A, I would like to have a dropdown box that shows my all linked records in table B - via a specific field (i.e. __pkTableBID).
When selecting a value (record) in that list, I would like to have the other fields related to table B showing the content of the chosen record.
I think it is easier to do - for your - than to explain - for me - but I am not sure how to set this up correctly.
Thanks in advance for your input!