I have linked a ‘products’ table and an ‘orders’ table. The products table lists the items but some of the items have multiple choices (such as colours, sizes and finishes). When the product is selected in the orders table, the options are grouped together and not selectable (i.e. it is a mirror of the original contents rather than a dropdown which is unique to the entry on the orders table and doesn’t change the main products data). I want to be able to select the specific options for each product on the orders table without having to create multiple products based on colours, sizes and finishes. I suspect it’s a formula or other method rather than just linking but I haven’t been able to find an answer online (as there are too many solutions for linking and I’m probably using the wrong terminology for my issue). Any ideas how to resolve?
This is not as urgent but it would be really handy if certain products were selectable based on other fields in orders table. For example, if a product is marked as country specific in the products table, then it would not appear in the orders table to select if the client was based in a different country.
Thanks in advance for any help.