AnsweredAssumed Answered

A value list that includes only related field values

Question asked by ABuchtel on Jul 4, 2014
Latest reply on Jul 5, 2014 by ABuchtel

Title

A value list that includes only related field values

Post

     Hello:

     I have an Order Table with these fields defined:

       Product Group

       Product ID

     When creating Records in the Order Table, I will first choose a Product Group, and then I want the "Product ID" field to be a Pop Up List that displays only Product IDs within the selected Product Group.

     I have a Products Table with the same fields defined (  Product Group,  Product ID )

     The Orders Table and Products Table are joined by the Product ID field.

     I duplicated the Products Table and joined the "Product Group" field in both "Products" and "Products 2".

     I have a layout based on the Order Table.  I have a Product Group Pop Up List that displays the 5 available Groups from a Value List. I have the Product ID field defined to use a Value List like so:

          "Use values from first field' (Products 2") Product ID

           Include only related values starting from Products

     I go into the Orders form, choose a Product Group, and when I click on Product ID, I get the message "no values defined".

     If anyone could advise me where I went astray, I would greatly appreciate it. Thank you. 

      

Outcomes