Confusion on the use of table joins and relations to combine tables

[DF_IH]

Hi All,

I have very limited Access experience. I used it briefly during higher education so forgive me if this question has a simple solution!

I am currently working on a post code lookup database. I have been asked to associate levels of deprivation in the UK with a post code.



I have 4 tables

• PC(2) - The main table I hope to join values to, each post code is unique so I set it as the primary key. There are many post codes for each LSOA code and the decile field is empty.
• SIMD - a table containing the LSOA codes of Scotland and the decile of SIMD rank, LSOA Code is unique in this table so I set it as the primary key.
• WIMD - a table containing the LSOA codes of Wales and the decile of WIMD rank, LSOA Code is unique in this table so I set it as the primary key.
• IMD - a table containing the LSOA codes of England and the decile of IMD rank, LSOA Code is unique in this table so I set it as the primary key

I am trying to join the tables so the values contained within the Decile field of the Welsh, Scottish and English tables populate the decile column of the PC(2) table. I have played around with relationships and query's and become overwhelmed and am aware I have no idea what I'm doing.



How would I go about joining the tables together?

Thank you and have a wonderful day!

[Minty]

I think you should have just two tables

PCD
LSOA11DC
DECLIES

and adjust your second table to have an extra field

LSOA11DC
COUNTRY
DECLIE

Then your query(s) should get much simpler, assuming the LSOA11DC fields are unique across the Country areas?

[Micron]

I believe there is a free simplified version here (note: I am not affiliated with the site). No idea if the design is available to you though should you need that.

https://www.mendipdatasystems.co.uk/...594138311.html