Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
dependent drop down list db value numeric not label
Thank you that worked, I had to change about 1000 fields, but problem is resolved. -
Need help with Foreign Keys
Ok I tried it and I could reference city to province. But when I try to reference suburb to city I get the following error: Cannot add or update a child row: a foreign key constraint fails (`pns_prop/#sql-990_9`, CONSTRAINT `#sql-990_9_ibfk_1` FOREIGN KEY (`idcity_suburb`) REFERENCES `city`... -
Need help with Foreign Keys
Can someone please help me to setup foreign keys between these 3 tables. I would like to setup the FK as follow: id_prov -->(FK)idprov_city and id_city -->(FK)idcity_suburb The problem I'm experiencing is when I feed my database using dependent dropdown menus the value used to control the... -
dependent drop down list db value numeric not label
Hi Hoe do I get the lable of my dependent dropdown menu to get inserted into the database instread of the value that controls its actions? Thanx
