Help would be appreciated with below form structure:
Fields:
Production Line - 1,2 & 3
Item Description
I would like the second dropdown list (item description) to narrow selection based on selecting line 1,2,3.
Database structure is:
itemdescription = Item Description
itemgroupcode = Defines line 1,2,3
How would I be able ...