Join muliple tables in one query field. PLEASE HELP!!!

[agh5147]

Bulizie, the Employee ID is unique to that specific employee. That's what I am using to link the tables.

[agh5147]

I am using the employee ID as the unique identifier that links the table together.

[Bulzie]

So each rescuer can only be on 1 team? Can the same Cert be required by multiple Teams? If so can it be required by one team but not required by another? Or required by a specific rescuer and required by another? Could a rescuers change teams?

[ssanfu]

PMFJI,

If done this way what would be your relationship links between tables? Also I wasn't going to use autonumber for the reason that the employee ids have both numbers and letters.

Then use a different name for the autonumber field.
You are using a text field to link tables... I never use text fields to link tables.

AutoNumber
Purpose Use an AutoNumber field to provide a unique value that serves no other purpose than to make each record unique. The most common use for an AutoNumber field is as a primary key, especially when no suitable natural key (a key that is based on a data field) is available.


See
Autonumbers--What they are NOT and What They Are
http://www.utteraccess.com/wiki/Autonumbers

Microsoft Access Tables: Primary Key Tips and Techniques <<-- read several times
http://www.fmsinc.com/free/newtips/primarykey.asp


This illustrates how to use an autonumber field to link tables: