A value list that includes only related field values
I have an Order Table with these fields defined:
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.