Referential Integrity Causing Me Problems

[Dave D]

I am having a bit of a problem with my table relationships. When I have a 1:M set for tblAttachInfo (as shown in the attachment) and I try to add a record through the tblContractIDs table, I get the error "You cannot add or change a record because a related record is required in tblParts."

If I remove referential integrity then I can add the record. I fail to see how there is any relationship between tblContractIDs and tblParts. The relationships are with tblAttachInfo.

I greatly appreciate any help with this. Thanks.

[June7]

Don't know if this is cause of issue, but appear to be circular references. Review http://www.codeproject.com/Articles/...atabase-Design

Table links should be on PK/FK fields. The link between tblContractIDs and tblSOWinfo does not involve a PK.

[Dave D]

Good catch on the primary key field for the tblContractIDs and tblSOWinfo - thanks.

This may be a circular reference but the information in the link you provided was difficult for me to follow. Sorry, this is not my strong suit. Any additional help is welcome.

[June7]

Not my strength either. Many experienced developers don't bother setting up relationships because users don't (shouldn't) interact directly with tables and queries. Data integrity is managed by interaction with data through forms.