I looked around here but couldn't find any answers to my question, or maybe I'm just not interpreting it right, anyways, here it goes:
I have a table: Manufacturing Requests, and embedded on that form there is a child table called MR Items. I also have a table on a different app called Vendors. I want to set up a cross app, many-to-many relationship that after creating a new MR Item, would allow a user to select up to 5 "Potential" Vendors using 5 dropdown fields.
I already set up MR Items < Vendors, and Vendors < MR Items. Now I'm stuck on creating 5 dropdown fields on the MR Items form that can be used independently from eachother.
I added a text and numeric reference field on the MR Items form to select "Vendor 1", and a second set of text/numeric reference fields to select "Vendor 2." But when I choose an option for "Vendor 1," it automatically changes all 4 fields to the same selection.
I'm not sure what the fields are on the MR Items form, because when I click on Customize this Form, and select the elements in the left pane, they show as:
"numeric (reference)' and "text (reference proxy)"
Then if I click the Properties button in the right pane, they show as:
"text (lookup)" and "numeric (reference)"
Finally, when I right click the field on the form and click Edit the properties for this field, they ALL show "numeric (reference)"