2 Replies Latest reply on Jul 5, 2014 3:49 PM by ABuchtel

    A value list that includes only related field values

    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.