Hello all:

I'm sure this is as simple as it gets but here goes:

I have a table with 2 fields: Player(Text) Active (Number). If Active is 1 the Player is Active else he's inactive.

I have an input form for another table where I would like to have a popup list showing ONLY the active players. There is no relationship connecting the 2 tables. What do I need to do to just show the active players.

Thanks.

DJC

Have you tried using a relationship and a Portal?

Define a calculation field in the first table (result is Text) =

Case ( Active ; Player )

In the second table, define a value list to show values from the calculation field.