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.
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.
