Subform entry violates referential integrity.

[Susilowati]

hi all,

I got a problem with my form this time.. this is extremely bizzarre!!
I am setting up a project log database.
Every project has a few implementation process.
Every implementation process has a few issues [one to many relationship],
and some processes have a few subprocesses [another one to many, not many to many though].

Now I'm creating a subform for user to input implementation issues, and everything works but one thing!
Everytime after I choose a process from a combo box, then entering the notes I like to put it, but leave the subprocess combo box blank, it will never let me move on to the next record!
It is saying that I can't add the record because a related record is required in the subprocesses table. But I thought I didn't mark it as "required", and some processes indeed do not have any sub processes anyway.

I have tried to change the relationship in a lot of ways to have it not as complicated as it should be, but still it doesn't solve the problem!
I have even tried to delete the relational integrity from the process-subprocess tables relationship just for testing, but still didn't work!
I have checked the query, and this form got nothing to do with the query... well at least i think nothing's wrong with them.

I'm honestly distressed, depressed! I should finish this database within short period of time!
I really need help! Please, anyone. Give me some clue! Any clue is more than welcome.

If my explanation is not clear enough, I shall provide more details.... Thanks everyone.

cheers

 

[ElsVanMiert]

I remember that I encountered this problem some years ago in Access 2.0.
The reason was the fact that the data from the Main form was not requeried when the subform got the focus.
If a new records was displayed in the Main form and I wanted to create a record in the subform then this was not possible since the table did not yet contain the data from the main form.
A simple "requery" of the Main form solved this problem.

 

[Susilowati]

hi
thanks for the reply. I have just figured out the problem though. I deleted one of the relationships [actually a shadow relationship] that caused a circle!! And guess what, it works!! Jeez can't tell you how excited I am!! Still, thank you thank you for the suggestion

cheers Susi