I want to create a input (dropdown) list with the name of the persons working on that company that is selected.
only the company's that only can be selected all got the same category (supplier)
So if the company is selected I want a drop down menu for the contact name of the supplier.
How do I need to link this.
My databases are:
- Contact information (name, category , company ID)
- Request_Presswork ( all suppliers (company id where category = supplier) - contact supplier)
How do I need to make this relation and input list?
Thank you for helping
Leverancier = Supplier
Contact = Name Contact person company that is above