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