Relationships

[Guest]

I am having a nightmare!!!

I have a database with two tables that I need to get information from.

The primary table contains all the personal details of an employee - its
primary key is autonumber.
The secondary table has been recently imported and is a list of the
employees qualifications - its primary key is autonumer.

My problem - I need to create a relationship between the two tables so that
I can use a query to produce a report from information from both tables. The
only problem being that the only information that is uniform between the two
tables is the forename and the surname. I can create a relationship between
forename and forename or between surname and surname but I can’t create both
at the same time. The other thing I thought about was keying the ID from
the first table into the second table to enable me to create a relationship
but that will cause problems when further information is added.

Can anyone tell me:

Is there a way of getting an ID number to cascade to all other tables
creating a common link?

Can anyone advise me how to get round the above relationship problem?

Thanks



Mandy

 

[Stefan Hoffmann]

hi Mandy,

I am having a nightmare!!!

That's simple: Just wake up.)

The other thing I thought about was keying the ID from
the first table into the second table to enable me to create a relationship
but that will cause problems when further information is added.

You should do the following:

- Create your two tables with referential integrity (over autonumbers).
- Import data only in a temporary table.
- Use a query to copy the data from the import table to your "live"
table adding the foreign key values.


mfG
--> stefan <--