Hello,
At the moment I have 3 forms:
- Drawing
- Customers
- Works order
When you add a drawing number, I use a "look up" to select the customer name from the Customers form. So the creator knows that a specific drawing number is tied to a customer.
In the Works order form, the user will select a customer from a drop down box, they then need to select a drawing number but at the moment it shows all the drawing numbers available.
Is it possible to filter the drawing numbers that are associated with the customer name?
Thanks in advance