Using a Conditional Value List to select records - help please?

[keelbolt]

I have a table with over 300 records containing the data of individual regions. Each region belongs to one of only ten provinces. I want to select a record for work by using a drop down list, but it makes sense for this to be a conditional list using the filter of the province to show only those regions in that particular province.

I have created a conditional value list by following the instructions in the filemaker manual, but this gives me a separate table and creates a whole load of new records, which I don't want or need.

Can anyone please help? I attach a simplified version of what I am trying to achieve - simply selecting a region's record by province then region name.

KBConditionalValueLists.fp7.zip

[bcooney]

You mention "region" but your sample file seems to call them "diocese."

It will not helpful to name your table new_Diocese. Just name the table Diocese. DioceseID needs to be set to an auto-enter serial. Also, don't prefix the field name with the table name. It's not necessary or really very helpful.

You are assigning Provinces to Diocese, right? You should have a table for Provinces (with a ProvinceID), and a foreign key in Diocese for its Province (_kF_ProvinceID). Set the foreign key to a popup using a value list of ProvinceID and Name (show just the second value).

I don't see the need for any conditional value list here.

[comment]

How about this way?

ConditionalValueList2.fp7.zip

[keelbolt]

That's brilliant! Thanks.