Hi guys,
I have a database to record daily issues to be resolved for my team.
I have a form where a customers postcode is entered and from this entry i want access to automatically fill in the corresponding email for the team that will deal with it so I can just copy and paste it straight into an email, save me looking up the postcode in my little book every time.
Upto now i have added a table with 2 columns, 1 with all UK postcodes (first 2 letters only) and the other with the email address for the team that deals with the post code.
Not sure if this is best way to do it but please tell me if another ways works better.
Anyway, what i want it when a postcode is entered, the corresponding email shows up next to it. all it needs to match is the first two letters of a postcode.
Any help on this would be great.
Thanks
-SneapDogg-
I have a database to record daily issues to be resolved for my team.
I have a form where a customers postcode is entered and from this entry i want access to automatically fill in the corresponding email for the team that will deal with it so I can just copy and paste it straight into an email, save me looking up the postcode in my little book every time.
Upto now i have added a table with 2 columns, 1 with all UK postcodes (first 2 letters only) and the other with the email address for the team that deals with the post code.
Not sure if this is best way to do it but please tell me if another ways works better.
Anyway, what i want it when a postcode is entered, the corresponding email shows up next to it. all it needs to match is the first two letters of a postcode.
Any help on this would be great.
Thanks
-SneapDogg-