I am experience brain flatulence and need some remedial assistance.
I am creating a data entry form. I have envisioned a tabbed format because I will have this idea utilized for Placement, Mentoring and Seminars data entry as well as recruitment. But I am open to other methods. Here is a description of what I have...
tblTeachers (this is the ONE)
tblRecruit (this is the MANY)
Form
=================
The problem I have is this:
I am creating a data entry form. I have envisioned a tabbed format because I will have this idea utilized for Placement, Mentoring and Seminars data entry as well as recruitment. But I am open to other methods. Here is a description of what I have...
tblTeachers (this is the ONE)
- Demographic data
tblRecruit (this is the MANY)
- recLocation
- recMethod
- recYear
- recSchool
Form
=================
- List of teachers available to allow a user to see who has already been entered to prevent duplication
- Use this same list for navigationrecord navigation
The problem I have is this:
- I have created a tabbed control that has the data entry fields
- I have created a subform to display ALL teachers from tblTeachers
- I do not know/remember how to link these so that the list may be used to to display the select record in the tabbed control
