:

I have a simple database for a sports club. The tables are Player, Team and Selection.

In the Player table is a field called Available. It is either "Y" or "N".

I want to populate a Selection Portal for each team using a value list of available players. I cant make the value list work. It either shows all players or only players previously selected.

Why can't I find the answer to my problem? What is the meaning of life? Sorry, I digressed ... :

Please help!

TIA

Langy!

}What is the meaning of life?

[big] 42 [/big]

42 - LOL!, Best book ever.

To be honest i don't get the question. Could you post a sample?

A sport club, that has many teams (table), wishes to record which players (table) play in given weeks and record goals and best player points etc.

The club records which players are 'unavailable' with a checkbox (field = Y). The transaction table is populated through a portal from the Teams table and a drop down list of AVAILABLE PLAYERS is required. I need help making this value list so that only AVAILABLE PLAYERS are shown ...

Thanks

You can have the player flagged as available. I personally would use a boolean number field with a checkbox. However in regards to your sample, you can create a calculation field and then reference that calc field for your drop down instead of the player field itself.

Case ( available = "Y"; PlayerName )

or if using boolean num flag

Case ( available; PlayerName )