Relational problem

[hakha4]

Hi!
New to Access and can't get relations to work as expected. The aim is to have 3 (maybe more in the future) tables that are related 1:1 and 1 table related 1:N ( se pic below)
I'll manage to relate mainTable and A ok with a primary key patID (counter) in mainTable and patID (integer) in TableA. But how to relate table B,C ... ? New counter? more than one field to relate??

I've tried a number of combinations but can't get the hang of it. Could someone point me out how to accomplish this. I've googled back and forth but can't find an answer for my question.
Any help appreciated
Regards Håkan

[isladogs]

Each table must have their own PK field.
If tables A, B & C will only ever have one record for each PatID there is no reason why you can't use PatID as the PK field for each
Otherwise give each their own PK field and use PatID as the FK field used for linking

The latter method MUST be used for table D

Suggest you add referential integrity to the tables once you've finished sorting out the relationships

[orange]

Håkan,

See the info in this link on Database Design and Planning info -videos and articles. You will find the tutorials in the article very helpful if you spend 30-45 minutes working through them. You will also find that starting with a clear description of what you are trying to do will greatly assist you in determining business rules and data relationships.
Good luck with your project.

[hakha4]

Thank's to both of you for answer. I'll try sorting it out!
Regards Håkan