ferraro
Posts: 1
|
| Posted: 10/21/2009, 3:14 AM |
|
Hi everyone, I have been implementing a web application for managing a set of employees. A simplified representation of the data base I am using is:
EMPLOYEE(ID, NAME, COUNTRY_ID, CITY_ID)
COUNTRY(ID, NAME)
CITY(COUNTRY_ID,ID,NAME)
(notice that I cannot modify the structure of COUNTRY and CITY tables)
I have been able to create a 'new employee' page where it is possible to input the city where the employee works by first selecting the name of his country and, then, choosing among the names of cities existing in that country. I have done this by using the Two dependant listbox example available (http://examples.codecharge.com/Ajax/DependentListBox2.php) by CCS.
However, when creating a 'browse/modify' page, I don't know how to display the name of the city (dependant on both the CITY_ID and COUNTRY_ID attributes) instead of the CITY_ID attribute.
Is there someone of you that could help me with this?
Thank you in advance,
Umberto Ferraro
|
 |
 |
ckroon
Posts: 869
|
| Posted: 10/22/2009, 2:00 PM |
|
If the record is storing the IDs of teh country/city rather than the actual name.. you should be fine.
_________________
Walter Kempees...you are dearly missed. |
|
|
|
|
