fjbosscha
Joined: 23 Feb 2005
Posts: 4
Posted: 2005-03-03 21:15
Back to top
Reply with quote
|
Is it possible, and if so how, to do the following:
I have a table with postalcode, street and place.
I have made a form with a table and a part of that is giving street, postalcode and place.
To make it easy for the user, they only need to select the postalcode. I know how to fill the values with postalcodes, but after a user has selected the postalcode, how can i get the values for street and place and put them in read-only field and after that in the database for this session.
Thanks for your reply,
Freerk Bosscha
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2005-03-09 21:22
Back to top
Reply with quote
|
the easiest way i see is to use before trigger. you can search zip code in db and change newly created row. (if you have only one city/address per zip code).
|
|
Post new topic
Reply to topic
|
|
|
Login
Registration
Slovak
