Access not showing all records in table...

[bradlannon]

Hi, I have a little issue that I cannot figure out! I have an application with a MS Access front end/back end. The problem is on a particular form frmEmployeeSpecificJob it only displayed 6 employee names in txtname field. There are in fact 12+ records in employees table...and this txtname textbox should display the all the records (as there don't seem to be any filtering...just pulling from a query that selects all records from 1 table...qryEmpWJobs) Anybody have any ideas?

I have attached the DB below if you think you can help! Thanks in advance and have a great day!!!


Brad

 

[ajetrumpet]

the problem is that your form is pulling from a JOIN query, and that it is reading only the records that have related records in the field called empID from the HoursEntry table, which are the 6 employees that you see in your form. If you only pull from the employees table without these joins, you will get all of the employees on the form.

Referential integrity doesn't help here either. That is part of the culprit.