- Sun Jul 10, 2022 11:57 pm
#830079
hello
i made 3 dropdown (country,city,village)
when i choose country just show its city and when i choose city just show its village
i made 3 pm tables
for country table name : G1MT ....fields ID,G1
for city table name : G2MT ....fields ID,G1,G2
for village table name : G3MT ....fields ID,G2,G3
between country and city is ok
drobdown country(filed name=g1):
select ID,G1
FROM
PMT_G1MT
dropdown city(filed name=g2):
select G1,G2
FROM
PMT_G2MT
WHERE G1=@@g1
now how can i add village(filed name=g3)?
select ????
i made 3 dropdown (country,city,village)
when i choose country just show its city and when i choose city just show its village
i made 3 pm tables
for country table name : G1MT ....fields ID,G1
for city table name : G2MT ....fields ID,G1,G2
for village table name : G3MT ....fields ID,G2,G3
between country and city is ok
drobdown country(filed name=g1):
select ID,G1
FROM
PMT_G1MT
dropdown city(filed name=g2):
select G1,G2
FROM
PMT_G2MT
WHERE G1=@@g1
now how can i add village(filed name=g3)?
select ????