Get Results from a table or query

[hessleroader]

Right here goes:

we have a table that has the following:

I do not want to get inton realtionships please i would rather use a query or something else that does not use relationship

[TblPostcode]
postcodeID, Postcode, Street, Town, County

The customers table has 4 different postcode fields with street, town etc

there is an invoice address, collection address, other collection address and delivery address which all have a postcode field
So there is:

InvPostcode
Coll1Postcode
Coll2Postcode
DelPostcode

Obviously the is InvStreet, InvTown etc..etc..

So what i am trying to do is on my customers form when i enter a new customer the invpostcode will lookup up postcode details in the postcode table and enter the results on the form, the same with collection address and delivery address

at the minute i have 4 different queries where i would really only like one
or some other way of getting the values

many thanks
simon