the right approach is to merge the two tables since they all define one persona
just provide categorization so as
you can separate the permanent from the employee through query.
to retrieve a value from one of the two table you normally run a query which
contain a field running a code
that wil
I'd
manage it as one table. You can add a field to designate whether the
employee is temp or perm.
Tom OakesPersonal PC Consultants,
Inc.[EMAIL PROTECTED]503.230.0911 (O)402.968.6946 (C)
-Original Message-From:
AccessDevelopers@yahoogroups.com
[mailto:[EMAIL PROTECTED
om
[mailto:[EMAIL PROTECTED] On Behalf Of pohantui
Sent: Tuesday, June 28, 2005 7:50 AM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] retrieve a value in a query from one or more
tables
Hi.
I've a table (training) and i also have another 2 tables
(PermanentEmployee dan Te
Hi.
I've a table (training) and i also have another 2 tables
(PermanentEmployee dan TemporaryEmployee).
Training table contains all employee trainings (subject of training,
employee id, start, finish, duration, charge and location.
PermanentEmployee table contains a list of permanent employees and
