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.

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. :)

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.