Discussions

 View Only
  • 1.  many to many - grid edit

    Posted 07-16-2019 17:30
    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. 


  • 2.  RE: many to many - grid edit

    Posted 07-29-2019 15:45
    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.