hceonetman
Technical User
I have a database with a table of employees (key field Pay_ID) and a table of training classes (key field Class_ID). I'd like to create a simple form/subform where main form is the class (date, location, content, etc) and the subform would be employees in attendance. Where I'm stuck is I'd like the user to be able to add items to the subform by picking them from a lookup. I created a table with Pay_ID and Class_ID to show which employees attended what classes. This table also has an autonumber key field. In this table, Pay_ID is selected from a lookup from the employee table by lastname.
The problem is when I create the subform, if I use the table as the data source it only shows class and pay ID fields which aren't very descriptive. If I use create a query to be the data source, I can't pick employees by last name. I could use a query for a view-only subform with a separate button to add employees, but this seems awkward.
HCEONETMAN
The problem is when I create the subform, if I use the table as the data source it only shows class and pay ID fields which aren't very descriptive. If I use create a query to be the data source, I can't pick employees by last name. I could use a query for a view-only subform with a separate button to add employees, but this seems awkward.
HCEONETMAN
