master child link problem

[icemonster]

ok.

i have done this like a lot of times and have checked this one over and over again and there is nothing wrong. i have two problems.

1 is with a form that i linked using the EmployeeID and the LogEmployeeID yet somehow, everytime i create a record, it doesn't auto populate or assign the main forms employeeid to that field.

2 is on my report, the subreport is not showing up for some reason and they both are linked using the PK of the form and the FK for the subform.

any clues what's causing this?

 

[Galaxiom]

Sounds right. Maybe someting corrupted in the form or table? Fact that it seems to affect both form and report suggest a table problem.

Suggest copying the table structure to a new table then inserting the records from the old table. Delete the old table and rename the new to the old name. (Don't rename the old table if you have NameAutoCorrect enabled.)

Otherwise can you post a sample database with just the essential objects and a few dummy records?