so ive been playing with cascading drop down lately, im currently using the state -> city example..
i already have state as a list and city as a list also with databasejoin element from state id with state name as the label.
heres my list
state
id -- state_name
1-- Texas
2-- Montana
City
id--state_id-- city_name
1--1--Dallas
2--1--Houston
3--2--Billings
the next list called "my info".. i have databasejoin element from state, then i created a cascading dropdown element with with city list as the data, but then i cannot chose the label in the data tab ? when i saved the CCD element, i also cannot chose the foreign key, i can choose the watch element which is state..
i dont know whats wrong,.. any help would be appreciated..
nb: this is in my local machine..
i already have state as a list and city as a list also with databasejoin element from state id with state name as the label.
heres my list
state
id -- state_name
1-- Texas
2-- Montana
City
id--state_id-- city_name
1--1--Dallas
2--1--Houston
3--2--Billings
the next list called "my info".. i have databasejoin element from state, then i created a cascading dropdown element with with city list as the data, but then i cannot chose the label in the data tab ? when i saved the CCD element, i also cannot chose the foreign key, i can choose the watch element which is state..
i dont know whats wrong,.. any help would be appreciated..
nb: this is in my local machine..