B
Bob
Hi,
I have a small database that records in one table, employees
and in another table, the work sites they have the necessary skills to work
at.
This results in a many to many relationship so I have created a third table
with the primary keys of the first two, as well as, the date the skill was
obtained.
Table details are as follows:
tblEmployees
EmployeeID
FirstName
LastName
001 Fred Bloggs
002 Joe Blow
tblWorkSite
WorksiteID
WorksiteName
001 Alpha
002 Beta
tblEmployee_WorkSite
EmployeeID
WorkSiteID
Date
001 002 2006-07-21
I am trying to create a form with list/combo boxes holding Name data (not
just ID numbers) from the first two tables and then inserting the chosen
data (ID numbers, this time) into the third table.
The data in tables 1 and 2 must not be changed.
Any ideas greatly appreciated
Bob
I have a small database that records in one table, employees
and in another table, the work sites they have the necessary skills to work
at.
This results in a many to many relationship so I have created a third table
with the primary keys of the first two, as well as, the date the skill was
obtained.
Table details are as follows:
tblEmployees
EmployeeID
FirstName
LastName
001 Fred Bloggs
002 Joe Blow
tblWorkSite
WorksiteID
WorksiteName
001 Alpha
002 Beta
tblEmployee_WorkSite
EmployeeID
WorkSiteID
Date
001 002 2006-07-21
I am trying to create a form with list/combo boxes holding Name data (not
just ID numbers) from the first two tables and then inserting the chosen
data (ID numbers, this time) into the third table.
The data in tables 1 and 2 must not be changed.
Any ideas greatly appreciated
Bob