okay, here goes. i have 4 tables l

[jon182]

okay, here goes.
i have 4 tables liked together,

town
building
postcode
street

these tables include relevant info, e.g postcode has many postcodes...
What iw ould like to do is in a form using a combo box use the postcode to search for a property, and then the other info linked with postcode, town, building etc would be displayed on screen. And this customers details could then be entered in another tables. It would be much faster than typing out addresses!!

Help would be much appreciated

Jon

 

[lespaul]

How are your tables linked together?

 

[jon182]

thanks for the reply
the tables are linked together without referential integrity