I’ve created two collections that are connected with a reference field. One collection is a list of “companies” and the second collection is a list of “products.” The reference field is located in the “products” collection and references which “company” that product belongs to.
I have a form for site members to list their “company,” so when they log in they can see any “company” they were the author of on their profile page. Now I want those site members to be able to use a second form to “add a product,” linking the product to the correct company using a dropdown on the form.
THE ISSUE I am having: Everything works and cross-references correctly, but the dropdown list contains ALL the companies in my “companies” collection, and I would only want each site member to see options of only “companies” they are the author of. No matter what I try in the settings, every time I link my form input dropdown to the referenced data, the options default to all entries in the referenced (“companies”) collection.
Is there a way that I can force the dropdown to ONLY show options from that referenced collection that were authored by the user signed in? The only thing I have found was to change the permissions of the referenced collection, but then I am not able to use that data to display on the front end of my site.
Thanks for any advice!!!