C
CaptDD
Ok, now I'm totally lost again....
I've created two additional tables so I now have three.
First table is Rep07 which is the data collected for each incident report.
Second table is Employees which is self explanatory.
Third table is Incident Employees.
I've created relationships between the three tables
[Rep07] relates RunNumber to [IncidentEployees] IncidentID
[Employees] relates IDNumber to [IncidentEmployees] EmployeeID
[Employees] relates Name to [IncidentEmployees] EmployeeName
I have a form Rescue which is based on the Rep07 table. I want to create
the subform for IncidentEmployees to reflect the employees that responded to
the incident for which the form is being completed.
The problem I'm having is how to create the subform to show a table in which
to all the list of employees that responded along with a combo box listing
all employees from which to choose to be entered into the subforms table?
I can get a subform table to show the EmployeeName field but can't figure
out how to use a combo box to retrieve the data.
This post is also referenced in my post
http://www.microsoft.com/office/com...d850d9f9e44&cat=&lang=&cr=&sloc=en-us&m=1&p=1
I've created two additional tables so I now have three.
First table is Rep07 which is the data collected for each incident report.
Second table is Employees which is self explanatory.
Third table is Incident Employees.
I've created relationships between the three tables
[Rep07] relates RunNumber to [IncidentEployees] IncidentID
[Employees] relates IDNumber to [IncidentEmployees] EmployeeID
[Employees] relates Name to [IncidentEmployees] EmployeeName
I have a form Rescue which is based on the Rep07 table. I want to create
the subform for IncidentEmployees to reflect the employees that responded to
the incident for which the form is being completed.
The problem I'm having is how to create the subform to show a table in which
to all the list of employees that responded along with a combo box listing
all employees from which to choose to be entered into the subforms table?
I can get a subform table to show the EmployeeName field but can't figure
out how to use a combo box to retrieve the data.
This post is also referenced in my post
http://www.microsoft.com/office/com...d850d9f9e44&cat=&lang=&cr=&sloc=en-us&m=1&p=1