Hi,

Is there a way i can navigate records via a value list? Some may say that such a technique would become unweildly as databases generally grow to contain thousands of records, but let me explain my situation...

I have a Suppliers table with 20 or so records and would like to do a layout where i can choose the supplier via a drop down list and then have the individual suppliers products appear in list form in a portal below. Obviously i already have a separate products table with a foreign key for the Supplier ID.

I could use the find functionality of Filemaker to select the Supplier, but it just seems to me to be a rather laborious way of doing what should be a simple task... Especially bearing in mind that there will never be that many suppliers and that things should be kept as simple as possible for the end user.

Thanks in advance for your replies.

Andy

Andy: This is pretty similar in nature to the question I answered for you before... same basic idea would go on here just create more table occurrences (TOs).

You might look at the "mock" dialog box technique using an extra window that I described from the "FileMaker Pro 9 Bible"

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