By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,950 Members | 1,005 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,950 IT Pros & Developers. It's quick & easy.

Referential Integrity problem. Related record is required in tableEmployee?

P: n/a
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.
Jul 6 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Sun, 6 Jul 2008 15:49:08 -0700 (PDT), "Ap******@gmail.com"
<Ap******@gmail.comwrote:

Perhaps you set a default value in the field's table design? Sometimes
Access sets a default value of 0 for an ID field and the related table
may not have such an entry. Take out those defaults.

-Tom.

>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.
Jul 7 '08 #2

P: n/a
Thanks Tom

That was the problem.
I would have gone nuts wasting time on that one.


On Jul 6, 8:51*pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Sun, 6 Jul 2008 15:49:08 -0700 (PDT), "ApexD...@gmail.com"

<ApexD...@gmail.comwrote:

Perhaps you set a default value in the field's table design? Sometimes
Access sets a default value of 0 for an ID field and the related table
may not have such an entry. Take out those defaults.

-Tom.
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.- Hide quoted text -

- Show quoted text -
Jul 7 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.