Add New - Lookup to another table, update multiple fields

This topic is locked

Add New - Lookup to another table, update multiple fields	3/10/2009 4:37:16 PM
PHPRunner General questions
M mrhappy author I have a table called Contacts. I have a table with fields City, State, Zip with all cities, states and zips. I can do a lookup from the Add New page and have a dropdown with the zipcodes displayed and update that 1 field. But, how can I select the zipcode and have it autopopulate the State and Zip too? I have a relationship from Table/Contacts/TheKey to Table/CSZ/CSZKey Would really appreciate any help. Thanks, Tim


R	rgfischerjr 3/10/2009
	I have a table called Contacts. I have a table with fields City, State, Zip with all cities, states and zips. I can do a lookup from the Add New page and have a dropdown with the zipcodes displayed and update that 1 field. But, how can I select the zipcode and have it autopopulate the State and Zip too? I have a relationship from Table/Contacts/TheKey to Table/CSZ/CSZKey Would really appreciate any help. Thanks, Tim See the video on Dependent Drop Downs...