Hi all,

I think these questions have been asked before, but I couldn't find them, so here goes.

I am setting up a database for a poker event. Each week I want to be able to enter FirstName LastName MemberNumber PlayerID in a database....I can do this....then I want to be able in another database lookup a player by using any one of the following: PlayerByFirst PlayerByLast or PlayerByMemberNumber and then input Date Position (place person came) so that i can then do a report of a number of weeks and see what the total positions have come.

Any Ideas guys?

Thanks in advance for any help received.

Milky.

My thoughts:

You should create a membership table for your players and their info like name phone and ID number.

A second table could be created for the events themselves. Place time and so on. Then updated with everyone that played and their rank and/ or take. Maybe this is a third table that relates back to an eventID?

I didn't understand what you meant by a 2nd database.