Hey guys! I have a question on the reference function between two tables.
In one view (we’ll call it “Products,”) I have a referenced column where I can select a “Client” from a drop down menu. Fantastic. But the reverse isn’t so fantastic. in the Client view, the reference showing their “products” has an add “New” link, which goes to the product input form. I don’t want that. I would prefer the “new” link on the client’s “products” list to go to the table list of all products so I can select a product that is already there.
Is this a thing? Can references and reverse references both function as a dropdown selection? I don’t even know if this is a UX issue or a behavior issue or a data issue.