City automatically entered from postcode

[malagasy]

hi, i'm pretty sure it's really basic to do but how do i make something that will automatically enter the city from the postcode.

As in...I enter 98800 and the city will be NOUMEA...I also want the list to be evolutive so if i enter a new postcode for a new city, next time, it will automatically do it.

regards

[The Big Bear]

Hi Malagasy

Make the field city a lookup field base on the relationship between Zip Code in the two tables.

Lionel

[malagasy]

sorry, but i'm really inexperienced...how should i do this ?

[malagasy]

i did it ! thanks