Results 1 to 2 of 2
  1. #1
    mehulkar is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Posts
    1

    FirstName + LastName

    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.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    First your players table should have a primary key, NOT the name as the primary key you could have 32 John Smith's in your tournament with no way to identify them individually. Secondly to combine their names in a query you could have this

    Contestant: Lastname & ", " & Firstname

    so your output on your query would look like

    Smith, John

    Your second table should contain the primary key of the players involved in the match NOT the name.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Concatenate firstname + lastname
    By Dega in forum Access
    Replies: 2
    Last Post: 08-11-2010, 04:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums