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 will search for both table, example,
SELECT getEmployeeID(....),... FROM ....
Public Function getEmployeeID(...) as ...
...
End Function
*********** REPLY SEPARATOR ***********
On 6/28/2005 at 12:49 PM pohantui wrote:
>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
>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.
>Yahoo! Groups Links
>
>
>
Harold Glenn P. Minerva, ECE
Sr. MIS Researcher
Cebu Port Authority
CIP Complex, North Reclamation Area, Cebu City
Telephone No.: 63 32 2321461 loc 36
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
