Hi all,
I have an MS Access 2007 database where I keep contact details of people. Data is input through a frm_CUSTOMERS and sent to the table tbl_CUSTOMERS which has the following fields:
What I want to do now is:
I have "sanitised" all the previous post codes and they are all correct now, but it was done manually, not using a reference to tbl_POSTCODES.
EDIT: Changed the tbl_POSTCODES fields
I have an MS Access 2007 database where I keep contact details of people. Data is input through a frm_CUSTOMERS and sent to the table tbl_CUSTOMERS which has the following fields:
- CUSTOMER_ID
- FULL_NAME (text field)
- ADDRESS (text field)
- COUNTY (lookup from tbl_COUNTIES)
- POSTCODE (text field)
- POSTCODE (Primary key)
- COUNTY (text field)
What I want to do now is:
- Update all the existing records of tbl_CUSTOMERS with entries from the newly created tbl_POSTCODES so that the post codes are pulled from there instead of the manually added post codes.
- Force the COUNTY field in tbl_CUSTOMERS to change according to which County is assigned to the specific post code in the tbl_POSTCODES
- Change the data enty form in such a way that when someone starts typing a post code, the field starts showing what can come after (hope this makes sense) and not allow any non-existent post codes to be typed.
- When Tab is pressed, the COUNTY field in the form to be automatically updated with the one that correlates with this post code as in tbl_POSTCODES.
- Then get rid of tbl_COUNTIES
I have "sanitised" all the previous post codes and they are all correct now, but it was done manually, not using a reference to tbl_POSTCODES.
EDIT: Changed the tbl_POSTCODES fields
Last edited: