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!