I have set up two files, "Items" and "Invoices". My Items file has a list of all the items we sell by category. I have a conditional value list set up in my Invoices file so that after I select a category from a pop-up menu only the items in that category show up for the next field's pop-up window. This works fine for the first row.
In the invoices file I have the category, item, qty., unit price, and ext. amount fields set up as repeating fields (8 rows). After entering an item in the first row, the second row always shows the value list from the category selected for the first row, and not the category I have selected for the second thru eighth rows.
This is my first experience with FMP, so I am not very familiar with the program, and I haven't been able to find any answers in the User's guide. Does anyone have any suggestions?
FMP 5.0 on PC
