So I'm new to access and I'm trying to create a database that will display the organizations and positions of all employees.
I have a couple of tables set up:
tblEmployees
tblInvolvement
The Employees table has a few fields per record that are supposed to link to the Involvement table. I have been trying to get the listbox to query and list the organizations and positions that each employee has.
Attached is what I have so far.
I am not sure where I am going wrong, but the listbox isn't pulling up anything.
Thanks in advance for any help.
-Power
I thought about using VBA and doing dlookups to check each field and then populate the listbox, but I will need to be able to generate reports where I can list employees by organization, by position, and organizations by employee (which is what the main form will actually be doing).