Team selection

[ian99]

I know I should be able to do this easily, but I'm just back from holiday and my brain is still fried. The problem: I want to populate 11 fields in one table called "games" with names of players selected from a pop-up that refers to a second table "teams" which contains a portal to a third table "players". That part is easy. However, if a name has already been selected for one position, I do not want the name to appear in the pop-up for other positions. I just can't get it to work. Anyone got any ideas???

[Oldsneekers]

Now this is just off the top of my head as it's the end of the day and my brain is a bit fried.

Make a calc field that is the concanotation of the 11 fields in Games. Eg: SelectedPlayersCc {Player1 & " " & Player2 & " " &...}

Next make a calc field in the table where your player data resides. Eg:

PlayerVLCc {Case(Pattern count (SelectedPlayersCc, Player1Name)=0, Player1Name; "") }

Next make your value list for the pop up based on the field PlayerVLCc.

Whether the field SelectPlayersCc is in games or teams tables depends on how you've structured those tables. You may need a Date time samp (or other marker) to relate the different tables to eachother. Hope this helps.

[ian99]

Many thanks. I can see the logic behind your reasoning. I'll give it a go when I get home tonight.