AnsweredAssumed Answered

Dropdown box to select a record in a 1 to N relationship?

Question asked by FredH on Nov 15, 2014
Latest reply on Nov 21, 2014 by philmodjunk

Title

Dropdown box to select a record in a 1 to N relationship?

Post

Hi experts,

 

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!
Kind regards,

_Fred_

 

Outcomes