Records not displaying properly

[JenNorthwood]

Hi There,

I am having problems with my database not showing the records properly. I know the records are there, but they will not show up in my forms properly. I have attached a sample of what I am trying to do. The main problem is in Oreination, it is not showing the people to the course.

Any suggestions whould be great.

Thanks,
Jen

 

[ghudson]

The problem I see is that all the records in the tblDateCourse have no values in the EmployeeID field. I discovered this in the forms record source qTrainingEDIT query.

 

[AncientOne]

Jen

Even if you rectify the error that has been found, you'll have difficulties. Your tables are poorly structured. You must address these weaknesses if you want your db to work well.
You shouldn't have eg EmployeeID in 3 tables. You should also have Training ID in a table which has a PK of DateCourseID and so on. Can you explain the difference between DateComp in your Course table and Date in your EmployeeTraining table?

 

[JenNorthwood]

Ok, I know my tables are not setup properly. I have been trying to get this one form to work for a very long time. I don't know how to link all the tables properly for it to record all the employees to the course, date and length.

I am not a programmer and I have not been working with Access very much anymore. I am just trying to get this to work for someone.

Any suggestions on how to create the tables properly and or where to place the fields properly would be greatly appreciated. I thank anyone that would be willing to help me.

I have looked at the many-to-many database from Pat Hartman, but I still just can't get my tables to work properly. I think I am trying to make things to complicated.

I have redone my tables, but I think I am still missing something. Please help

Thanks,
Jen