I'd
manage it as one table. You can add a field to designate whether the
employee is temp or perm.
Tom Oakes
Personal PC Consultants,
Inc.
[EMAIL PROTECTED]
503.230.0911 (O)
402.968.6946 (C)
-----Original Message-----Hi.
From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED]On Behalf Of pohantui
Sent: Tuesday, June 28, 2005 5:50 AM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] retrieve a value in a query from one or more tables
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
TemporaryEmployee contains a list of temporary employees.
How to retrieve a value (employee id) from one of the two tables with
a query?
or
what's the best, merge the two table (Permanet and temporary employee)
into one table or leave them as two separate tables?
thanks,
poh an tui
Please zip all files prior to uploading to Files section.
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
