Newbie with "violates referential integrity rules"

[DSL70]

I am hoping someone can help me out - I am new to access and I am trying to set a relationship between two tables, with the data types the same but keeps coming up with violates referential integrity rules....and I simply do not understand what this means, and how to solve it...

I have attached the file for reference.

[Beetle]

OK, so which fields are the ones on which you were trying to establish a relationship?

[DSL70]

Sorry - The Job ID and ID.

[Beetle]

You can't establish the relationship on two primary key fields. If tblJobDetail is intended to be the child table then you need to add an additional field (named JobID or JobIDFK, something like that) to tblJobDetail. Make it a Number data type and then establish your relationship between JobID in tblJobOrder and the new field in tblJobDetails.

[DSL70]

So do I make my new JobIDFK field the primary field? If I do Access advises "index or primary key cannot contain a Null value"... If I made this an Autonumber, would that help?

[Beetle]

No. It's a foreign key, not a primary key. Leave the existing PK field in tblJobDetail unchanged.

[DSL70]

Thank you!