Creating a value list based on another

[indium]

Hi

I'm building my first database in FM Pro 9 and have the following problem:

I have two tables. The first contains contact names and uses a drop down value list with hard coded options to determine the type of contact (client, supplier, staff etc).

What I'd like to do is populate a drop down value list in a second, related table only with the contacts from the first table that are defined as suppliers.

Could somebody give me some pointers on how best to achieve this?

Thank you.

[Vaughan]

These are called "conditional value lists" do a search on the Forums for some information.

Basically, your contacts need to have a "Type" field that identifies them as supplier, etc. A conditional value list is then defined, based on the selected Type, to list all the contacts.

It's easier to DO than it is to EXPLAIN. :)

[indium]

Hi Vaughan

Thank you for your reply.

I'm still having no luck with getting this done.

I've tried creating a value list in my second table based on related values in the first, but there doesn't seem to be a way to specify that the value of the 'Contact Type' drop down list should be 'Supplier' in any of the dialog boxes associated with creating a new value list.

In essence, I can pull the contact values into my second table fine as a value list, but I can't filter out those contacts which aren't defined in my first table as 'Supplier'.

I've also tried numerous calculations to try and give me what I need, but I still can't generate the correct set of results for my second table.

Could you (or someone else) walk me through what I need to do?

Thanks in advance.