| | |
|
|
|
Subdatatasheet made up of 2 tables |
|---|
| message from =?Utf-8?B?S2FzaWE=?= on 20 May 2004 |
I have set up a database consisting of employees. The main table consists of employee names and the subdatasheet contains each employee's work history (temporary assignments and permanent placements). Currently, the history is on one table, but I would like to separate it so that I have a table for temporary assignments and a table for permanent placements, but still have the complete history on one subdatasheet. Is there a way to link the two tables so all the information appears under one subdatasheet? Any suggestions would be greatly appriciated.
Thanks for your help!
|
| Joan Wild replied to =?Utf-8?B?S2FzaWE=?= on 20 May 2004 |
You really don't want to have two tables. Just add a field to indicate if
the record is 'temporary' or 'permanent'. You'll save yourself a lot of
grief. It will be easy to query for either type.
Also, because you used the word subdatasheet, you should be aware that this
can affect performance
http://www.granite.ab.ca/access/performancefaq.htm
You can create a form/subform to display/edit the information. Users should
be accessing your data via forms anyway.
|
|
Archived message: Subdatatasheet made up of 2 tables (Microsoft Access Error Message)
