PLEASE HELP......UNABLE TO ADD A RECORD

[jdwm2310]

Guys,

After I finish entering information into the SIP form I get a message stating that I can't add/change a record b/c a related record is required in table Employee. But in my Employee table I have not assign any field to be required...Any suggestions will be appreciated.

 

[LonnieJohnson]

It sounds like it's looking for a record with the same unique indentifier to appear in the Employee table. This may be saying something about your relationship between a main form and subform, or a join in a query that you may have as a record source for your form.

Just a thought... ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[ChemistZ]

That message definitely means that there is a relationship between your SIP table and the Employees table. Maybe you are either leaving the employee field blank or enetering an employee id that does not exist in the employees table. Just a thought.