bluenose76
Registered User.
- Local time
- Today, 12:30
- Joined
- Nov 28, 2004
- Messages
- 127
Hi,
I am trying to create a new DB from scratch and need a little advice.
My aim is to chart the career history of many people in my DB and my intention is to achieve this with two "Main" tables with many smaller tables linked to it.
Table 1 will contain the generic data about the individual, employee number, name, DOB, etc etc (there are many more fields) and Table 2 would hold their career history. Where they have worked, when, etc.
When viewing Table 1, I see all data, including a sub table showing career history, which is great. What I would like to do however, is have a query that will return all data from table 1 and Table 2 that refer to the employee number.
Attempts that I have made thus far, mean I have to enter the employee number twice (I would prefer to enter this only once) and then it gives me many pages (in report view) each page has all data from table 1, and one entry from table 2.
I would like to see all data from table 1 and then all data from table two, listed.
I know the above is quite long winded, so thank you for taking the time to read my post, and I hope that there is someone out there who may be able to help me with my quest.
Thank you
Regards,
Arran
I am trying to create a new DB from scratch and need a little advice.
My aim is to chart the career history of many people in my DB and my intention is to achieve this with two "Main" tables with many smaller tables linked to it.
Table 1 will contain the generic data about the individual, employee number, name, DOB, etc etc (there are many more fields) and Table 2 would hold their career history. Where they have worked, when, etc.
When viewing Table 1, I see all data, including a sub table showing career history, which is great. What I would like to do however, is have a query that will return all data from table 1 and Table 2 that refer to the employee number.
Attempts that I have made thus far, mean I have to enter the employee number twice (I would prefer to enter this only once) and then it gives me many pages (in report view) each page has all data from table 1, and one entry from table 2.
I would like to see all data from table 1 and then all data from table two, listed.
I know the above is quite long winded, so thank you for taking the time to read my post, and I hope that there is someone out there who may be able to help me with my quest.
Thank you
Regards,
Arran
