Adding info to table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cora B - 28 Mar 2007 00:54 GMT

I have a table with 21 fields. 3 of them are: tel no, cell no, and employee
no. I have a table where I enter information for jobs, and I would like to
have 3 pieces of info added without having to enter them each time I enter
job info. The employee info is in a separate table ( employees).

Reply to this Message

mscertified - 28 Mar 2007 16:12 GMT

There should be no need to have those fields in your main table at all. You
should have a separate Employee table and you link that table to your main
table via the primary key. In your main table you have the foreign key of the
Employee record.
remember to define this relationship in Tools--Table Relationships.

-Dorian

> I have a table with 21 fields. 3 of them are: tel no, cell no, and employee
> no. I have a table where I enter information for jobs, and I would like to
> have 3 pieces of info added without having to enter them each time I enter
> job info. The employee info is in a separate table ( employees).

Reply to this Message