I have searched but I cant seem to find an answer…
So, the app I am creating has three tables for the purposes of this question - the first is a list of “Items”, the second a list of “Item Types” and the third is a list of “Item Manufacturers”.
In my “Items” table I have a field titled “Item Type” which has a one to many relationship to the “Item Type” table and I can select the relevant item type in the “Items” form.
However, I want the “Items” form to have a field in it calleds “Item Manufacturer” where I can select the manufacturer of the item - but I only want it to show me options based on the value selected in the “Items” form under the “Item Type” field.
I created a table called “Item-Manufacturer” and I have two fields in it. One called “Manufacturer” (short text) and the other called “Item Type” (which is connected to the Item Types table) where I can select one or more item types applicable to that manufacturer - EXAMPLE for manufacturer SAMSUNG I would want to be able to select item type MOBILE PHONE and LAPTOP COMPUTER but not SUITCASE.
All OK so far… the problem comes when I go to the “Items” form and I want the “Item Manufacturer” field in that form to show me a filtered list of the Manufacturers based on the item type already chosen e.g. In the “Items” form, If I have selected “Laptop Computer” in the item type field, I would only want to see "SAMSUNG"in the Item Manufacturer field… so far all it does is just show me all of the Manufacturers irrespective of the “Item Type” selected… any ideas? Thanks in advance
Possibly the below will help / inspire?
