Hi,
I'm trying to create a template, where a user selects a response in a
dropdown box, and other fields are auto filed based on the answer.

As an example, imagine that you have a list of coffee shops, and you want to
select a town from a drop down list. Based on your selection, cells in the
table will be populated with street name and postcode for the coffee shop in
that town.

My particular template needs to cover several areas so I can either create
one per area, or one that covers all. A key part of creating this template is
that it has to be easy to manage should any key information change; therefore
I'd prefer not to use code if possible. Is there a simple way to do this?

Thanks

Doug