many to many - grid edit

  • 0
  • 1
  • Question
  • Updated 3 weeks ago
  • In Progress
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. 
Photo of Apryl Stoldt

Apryl Stoldt

  • 362 Points 250 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
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.