Adding info to table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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).
 
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
 
Back
Top