Solved Normalization - Struggles In Access

[dalski]

CJ_London's helped me alot in the past too & on other site, I'm most grateful.

 

[Pat Hartman]

Looks to me like @MajP solved your problem this time unless you are communicating privately with CJ.

 

[CJ_London]

unless you are communicating privately with CJ.

Nope

 

[dalski]

Looks to me like @MajP solved your problem this time unless you are communicating privately with CJ.

Obviously, just expressing gratitude for other help from CJ. Lost count the amount of times I've thanked @MajP

 

[raziel3]

In post #9 I noticed that ResLiblD is the PK in 2 tables. Is it a typo?

I believe this is the correct Relationship, and it will make the data much easier. However, it will make the form design more challenging.

View attachment 117880

 

[MajP]

In post #9 I noticed that ResLiblD is the PK in 2 tables. Is it a typo?

Looks like a complete duplicate table that the OP forgot to delete. I do not think it is used anywhere. Probably changed the name and forgot to get rid of it.