people from table not showing in form

[corystemp]

When I open my form it shows the first person in my table yet when I try to go to the next record its is blank. When I look in my table though I have a second person. I think it is b/c The second person has no training info added. But what do i do if that person has had no training? Is there way to fix this. I have attached a copy i hope someone can help.

PLEASE HELP !!!!!!!!!!!!!!!!!!!!

[rommelgenlight]

i saw your SAFETY REVISION sample. i can see now that you have set your data entry to no.

what I have noticed now is that you have two tables inner joined by id. you made this because you are posting on two tabs from which this two are link to two tables, EMPLOYEES TABLE AND LAMPSON TABLE.

you will encounter problem because your form RECORD SOURCE is a query of two tables which is inappropriate.

my advice is, make a subform for your LAMPSON TABLE on that form so that the ONLY record source of your Employees Form is Employees ONLY. if you have the subform of LAMPSON on your employees form then, just use the LINK (CHILD/MASTER) FIELDS.

[RuralGuy]

rommelgenlight has a good point about the Form/SubForm suggestion. Have you done any reading on Normalization? I made a change but you really need to examine your table structure carefully.