Hey everyone - I appreciate all of your input on my current issue.
Currently I have 3 Tables:
Table1_RawData contains collection of data
Table2_PgmData contains event information
Table3_EmpData contains employee data
I would like to create a form that will illustrate a record selected in the Table2, then pull Table3 employee name as a lookup / multi value check box to select each employee that is participating in the event from Table 2. Then click on "Add" button on the form to populate the event selected from Table2 and added a record to Table1, for each employee selected (Multi-Value check box) on the form, the event they attended.
The data entry person complains that it is time consuming to add an event to each employee individually whereas if a group of employees attended the same event - it would be great to select an event and pick from a list of employee to be added to the database (table1).
Is above possible - I am not able to gather any clues from Google Searches to come up with a solution.
This is a solution I needed last year...sorry folks for the delayed challenge here....
Gil