You'll need to look at the options you've selected in the Inspector's data tab and the settings for this value list in Manage | Value Lists...
Obviously, something there isn't selected correctly, but it's hard to guess which omission or other error is producing this result.
You describe this as a "custom value list" but you also describe having a countries table. The fact that you have a table of countries suggests that you should not use a custom value list but rather you should use the specify Field option to list the countries from your countries table. If this is what you have done, you might check the data type and indexing of the field in this countries table. It should be text, not number when you check it in Manage | Database | Fields and indexing should be enabled.
Spotted thanks. I had the wrong table selected.
I am not using the countries table as seems pointless if I can use a custom value list.
Using the countries table instead of a custom value list--can eliminate the need for maintaining two identical lists of the same information.
Your answer worked on my 1st solution but now...
I have a tab that relates to secondary locations. I need to place a feild that contains the primary location that is a drop down list so the user can enter information regarding secondary locations WITHIN the primary location;
HomeFarm (Primary location) Hill Wood (secondary location)
The user selects homeFarm from the dropdown lsit and then enters data regarding Hill wood.
Estate and secondary locations are two tables.
Drop down list doesn't work.
Can I do this?
So if you select "HomeFarm" your value list only should list secondary locations appropriate for "HomeFarm" and selecting a different primary location produces a different list of secondary locations?
If so, this is called a conditional value list:
Forum Tutorial: Custom Value List?
Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list
"So if you select "HomeFarm" your value list only should list secondary locations appropriate for "HomeFarm" and selecting a different primary location produces a different list of secondary locations?"
Yes this is correct. But what I am trying to do is thus;
I have a new layout for secondary locations. In this are 3 fields;
Estate Name (drop downlist which should list primary locations to choose from)
Seondary Location Name
Its the estate name that should be a drop down list but for the life of me I cannot get it to list anything even though there is a TO of Estate called estate2 that has a relationship to Secondary Locations table
The the TO of Estate isn't a factor here. You need a relationship linking the TO of your layout to the table of secondary location records and the TO of your secondary locations table used in this relationship is what should be the source of values for your value lists. Then you can specify "include only related values starting from [Select the TO of your layout here]."
A "mental model" that I find useful is that I look at my relationships and ask myself: "If I put a portal to my table of conditional values on this layout, would it display the values I want to see in my conditional value list?" If the answer is yes, I have a relationship I can use to set up the conditional value list, selecting the portal's TO as the table occurrence from which to specify fields and the layout's TO as the "starting from" TO.
I have sent you an email with the relationships screen shot.
You can see the relationships that we have been refering to in this article are highlighted in BROWN.
AN estate has a LOCATION. a LOCATION can have Multiple PRIMARY LOCATIONS and PRIMARY LOCATIONS can have Multiple SECONDARY_LOCATIONS.
Hope this make sense.