I am making an Access database to keep record of vacation schedule.
The tables I set up are:
To set up the database I do create a unique key for each table named:
I put the EmployeeID field in each table and link the Employee table to all the othet tables.
I bulid one query using all the tables and then a form using all the fields from the query.
When I look at the form in the form view it is completely blank.
If I use the tables individually I see the fields but not when I use the query.
Could someone help me as to what the problem is.