extra table required

sorry for previous post -pressed the wrong button too early!

I am setting up a database which contains a linked table from another
database and cant decide whether to add fields to the linked table or create
a table specially for this database.
It is a training database and the linked table holds information on name,
post, location etc. The training table holds information on what awards the
people are working towards, the status of the award, start dates etc. I need
to put a candidate number and whether the person is registered or not. This
relates to the person and not the award. Do I add the fields to the existing
(linked)table or should I set up a separate table holding only these 2 fields
(along with the employeeID to link)
I cannot see any reason not to do either, but am worried if I go down one
route, it will turn out to be incorrect later. Is there an obvious yes or no?

I believe you cannot modify a linked table, so creating a table specifically
for the needs of this database would be the way to go.

"lynn atkinson" wrote:

sorry for previous post -pressed the wrong button too early!

I am setting up a database which contains a linked table from another
database and cant decide whether to add fields to the linked table or create
a table specially for this database.
It is a training database and the linked table holds information on name,
post, location etc. The training table holds information on what awards the
people are working towards, the status of the award, start dates etc. I need
to put a candidate number and whether the person is registered or not. This
relates to the person and not the award. Do I add the fields to the existing
(linked)table or should I set up a separate table holding only these 2 fields
(along with the employeeID to link)
I cannot see any reason not to do either, but am worried if I go down one
route, it will turn out to be incorrect later. Is there an obvious yes or no?

Lynn,
If the 2 fields you need to add represent attributes that are needed for all
persons in the people table, then I would add it to the linked table.
Typically you would create a separate table if you had a small subset of the
people table for which these attributes are needed.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html



"lynn atkinson" wrote in message
...
sorry for previous post -pressed the wrong button too early!

I am setting up a database which contains a linked table from another
database and cant decide whether to add fields to the linked table or
create
a table specially for this database.
It is a training database and the linked table holds information on name,
post, location etc. The training table holds information on what awards
the
people are working towards, the status of the award, start dates etc. I
need
to put a candidate number and whether the person is registered or not.
This
relates to the person and not the award. Do I add the fields to the
existing
(linked)table or should I set up a separate table holding only these 2
fields
(along with the employeeID to link)
I cannot see any reason not to do either, but am worried if I go down one
route, it will turn out to be incorrect later. Is there an obvious yes or
no?