Hello everybody,
Here is my problem;
I am working on a real estate database and i have some problem with the linking of the City and the Zip code.
i have the first table Propertythat contain a field named ZipCodeand a second table(city) with Zipand Cityfields.
i would really like, when the user enter the ZipCode of a city, it directly propose him a list with correspond city and zipcode ( i managed to do that with concat(zip,'',city)in the display field. )
the problem is that i dont want to have a huge database of 40K city and zipcode i just need the city concerned so i would like to "allow to add new values on the fly". i checked the option and i tried dropdown box, edit with ajax etc... and it doesnt work. it doesnt allow me to add the city and the zipcode and it simply add NULL NULL to the city table.
maybe i didn't configured rightly the link beetween 2 database. i dont know.
Thanks for taking time to read this and Thanks for your help.