Posting this in General as I wasn’t sure whether it best fit under Tables, Queries or Forms.
In table ‘People’, upon a user entering their house number and postcode (UK zipcode), I need the ‘Area’ field to be populated accordingly based on the addresses stored in the ‘FS_Area’ table.
What would be the best way for me to achieve this? If the area was based solely on postcode I think I could do this using some sort of lookup, but the problem is that one postcode can contain more than one Area so the house number needs to be taken into account. For example in postcode LA1 1AA, house number 30 might be in AreaOne and house number 31 might be in AreaTwo.
Another requirement I have is that if the user enters an address that does not exist in the ‘FS_Area’ table, I would want their record in the ‘People’ table to show “Not in Area” under the ‘Area’ field.
From the user’s perspective the information will be entered using the a Form interface.
Any help would be greatly appreciated, I’m still very much a newbie when it comes to Access developing so I’m learning as I go along.
If there’s any info I’ve missed or isn’t clear, please let me know and I can give more detail.
Thanks in advance.
In table ‘People’, upon a user entering their house number and postcode (UK zipcode), I need the ‘Area’ field to be populated accordingly based on the addresses stored in the ‘FS_Area’ table.
What would be the best way for me to achieve this? If the area was based solely on postcode I think I could do this using some sort of lookup, but the problem is that one postcode can contain more than one Area so the house number needs to be taken into account. For example in postcode LA1 1AA, house number 30 might be in AreaOne and house number 31 might be in AreaTwo.
Another requirement I have is that if the user enters an address that does not exist in the ‘FS_Area’ table, I would want their record in the ‘People’ table to show “Not in Area” under the ‘Area’ field.
From the user’s perspective the information will be entered using the a Form interface.
Any help would be greatly appreciated, I’m still very much a newbie when it comes to Access developing so I’m learning as I go along.
If there’s any info I’ve missed or isn’t clear, please let me know and I can give more detail.
Thanks in advance.