Dear all,
I have seen this question posted in several forums but I can't simply understand the answers and I'm sure that it's very simple.
I have a form filling the table "cases" where a combo box in a form picks the options from a table called "services". There is a relationship enforcing integrity (one to many)
The problem is that services is optional and if I don´t fill anything, when attempting to create a new record, I get the error "You cannot add or change a record because a related record is required in tblServices"
I can see that the problem is that if i don't choose and option, access is setting the default value as "0" and there isn't any "0" key in the table "services"
In the combo box propertied the "default value" option is empty.
I'm not sure what I am missing.
It obviously work if I unmark the "enforce data integrity" in the relationship.
I have seen this question posted in several forums but I can't simply understand the answers and I'm sure that it's very simple.
I have a form filling the table "cases" where a combo box in a form picks the options from a table called "services". There is a relationship enforcing integrity (one to many)
The problem is that services is optional and if I don´t fill anything, when attempting to create a new record, I get the error "You cannot add or change a record because a related record is required in tblServices"
I can see that the problem is that if i don't choose and option, access is setting the default value as "0" and there isn't any "0" key in the table "services"
In the combo box propertied the "default value" option is empty.
I'm not sure what I am missing.
It obviously work if I unmark the "enforce data integrity" in the relationship.
Last edited: