Page 1 of 1

Post Codes

PostPosted: Thu Dec 16, 2010 12:20 am
by MiltonTrickey
Hi All,

I have a table called postcodes with 4 feilds
IDPostcode
Postcode
Suburb
State

there are approx 9500 records imported from an excel file.

What I would like to do is for the user to click on a drop down box of the postcodes and when the user chooses a suburb, the postcode and state are auto entered into their particular field.

Can this be done in other tables using the same process?

Regards

Milton Trickey.

PostPosted: Thu Dec 16, 2010 7:55 am
by John Sindelar
Sure. That is simply a lookup provided there is a relationship from the suburb being entered to the suburb in your post codes database.