Skip to main content
Question

many to many - grid edit

I have 4 tables, Jobs, site visit, sitevisit-orders, and orders.

job can have many site visits
job can have many orders 
sitevisit can have many orders
order can have many site visits
 - sitevisit-orders is the joining table between site visit and orders

from the sitevisit form I want to be able to select what order they are reviewing, the orders list needs to be a conditional drop down of orders related to that job, I also want to do this in grid edit mode. How do I get the drop down list in sitevisit-orders to only list orders related to the job. 
    This topic has been closed for replies.

    In the 'Related Order' field, you'll need to set up the Conditional Drop-down selections. You'll find this listed as 'Conditional Values' in the properties. 
    Terms & ConditionsAccessibility statement