469,616 Members | 1,823 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,616 developers. It's quick & easy.

Referential Integrity problem. Related record is required in tableEmployee?

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
2 3587
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
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.

Similar topics

2 posts views Thread by Bob Rogers | last post: by
3 posts views Thread by Wayne | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.