How to use value lists from different tables?

[luka]

Hi,

I'm fairly new to FM and am using FMP7.

I'm creating and Invoice database which has a list of Invoice Items.

Each Item has a pop-up list to first select the product type we are trying to place in the invoice.

I then want the product name field to have a pop-up list containing product of the selected category.

Now the trick is that each product category is a different table.

How do I get the pop-up list to look into a different table to create a value list, based on the input of the 'category' field.

This seems fairly straightforward, but the FM tools arent' allowing me to do this in an obvious way.

Help is appreciated,

thanks

Luka.

[-Queue-]

Why is each product category in its own table? Why not have a table that has one record for each product-category combination? You can easily make a conditional value list with that setup.