Referential Integrity problem. Related record is required in table Employee?
in [Help]
|
From: ApexData on 6 Jul 2008 18:49 Access2000, using a continuous form. I’m getting a message that say “you cannot add or change a record because a related record is required in table Employee”. This occurs in all my combobox fields that have referential integrity linked to another table. I do not have the field in the table set as required, and I do not want to require the entry. If the record is filled out completely and added to the table, you can go back to the same record and eliminate the data in the fields that have referential integrity and it saves without complaint. My problem is that when a New Record is created and I fail to enter data in the fields that have referential integrity set, I get the error message. Why? I simply want to create a NewRecord and not require data to be entered in the fields that have referential integrity.
|
Pages: 1 Prev: Maximise Access window Next: Probs w/ A97 example code using Application.FileSearch |