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.