Sharing data

  • Thread starter Thread starter Jackie
  • Start date Start date
J

Jackie

I want to create a database for the local fair board. One
table would be the Exhibitors table and one would be the
Entry table.

Exhibitors table fields:
Exhibitor number
First Name
Last Name

Entry table:
Exhibitor number
Entry number
First Name
Last Name

Is there a way to get the first name and last name from
the Exhibitor table to appear in the Entry table without
retyping them? One person as an exhibitor could end up
with several different entries. Any help would be
appreciated. Thank you for your time and advice in
advance.
 
In a relational database, you do not want the first and last names to appear
in the Entry table. Instead, you use a query to display the desired results.
Your table structure correctly uses the Exhibitor number in the Entry table
as the link; so you use a query to look up the first and last names from the
Exhibitors table. Something like this:

SELECT X.[Exhibitor number], X.[First Name] & " " X.[Last Name], N.[Entry
number]
FROM Entry AS N INNER JOIN Exhibitors AS X
ON N.[Exhibitor number] = X.[Exhibitor number];
 
Back
Top