I'm getting back into access after a long time and I'm having trouble with something that should be really easy.
I have a table with the contact details of a member list of the group. Two fields in this table are "FirstName" and "LastName".
I have a second table in which there are going to be multiple records relating to each person (tennis matches played by the person including date/time and result). In this Matchplay table, I want just one field called "Name" to be related back to the player.
How to I combine the FirstName, LastName fields in the Player table to enforce referential integrity with the 2nd table?
Let me know if this question needs more clarification.