Technicaly Possible? Conditional Lists

[csrjw]

I have two separate files. One is a Sales Order.fp7 containg records holding my sales data. The second file is an Inventory.fp7 containing my product inventory. My inventory is setup so that each item has a category. For example, Main Category --> Fruit, Item --> Apple. I have setup on my Sales Order screen the ability to choose the Main Category using a dropdown list. I now want to filter the choices based on the Main Category selection. Is this possible across two seperate files, or do both tables need to be in one file? Thanks!

[Genx]

3 Links that might help you.

http://www.fmforums.com/forum/showtopic.php?tid/177787

http://www.fmforums.com/forum/showtopic.php?tid/177731

http://fmforums.com/forum/showtopic.php?tid/177620/