I have a list of suppliers we use in one data table. That list is used in a dropdown when we are first recording an order to pick which supplier we are using.
Now I have a repeating table with filters to display all of the orders we have done. I tried using the data field that was stored in the repeating table, however I was getting duplicate values in my dropdown when I only want 1 option in the dropdown for each unique supplier…
Is it possible to filter a repeating group with a dropdown from a totally different data table?
Thank you!