Displaying multiple ref columns in form

[Binkodyl]

I have 8 tables in my app. One of them is my main table. In the other 7 tables I have a reference column that points to the key of my main table. In the first section of my form, I have columns for [Name], [Position], [Section], and [Location Id]. [Name] should be a dropdown that has values from my Users Table. [Position] should select the position of the name selected. I want to be able to add more than one name and position in a form entry. How do I make the references between tables to do what I want in my form?

[Steve]

You’d need to have multiple Name and Position pairs, like Name2, Position2, Name3, Position3, etc.