stevenator65

I am making a database of football players for our fantasy draft. In my Transactions table I have a lookup field that finds the players from the Players table. I want the chosen players to disappear from the lookup once they are chosen, but I can't figure out how.

I have 3 tables:
Fantasy Teams
Players
Transactions

I am using Access 2007.

Thanks for any help.

Box

It's been a long time, so I'm very rusty, so I may be very wrong.

I think you need to create a query, which players haven't been picked, and use that as your look up.
Access can get very convoluted, it seems like you have to create everything before anything will work.

Anyway, just writing this has made me realize how much I have forgotten.

Hope you get a better answer than this gibberish.

stevenator65

Thanks Box. My research tells me to use a combo box in a form rather than a lookup. I must design a new query to eliminate chosen players. I'm rusty too.