Custom Dropdown OnSelected

can you not use the dependant dropdown feature in the page where you set up the dropdown?

I wanted to do that, but the field doesn't appear in the 'Category Control' drop down.
So I have the following layout:

1)Table 1 is the main table, it has a foreign Key for table 2.

2)Table 2 has a foreign key for table 3.
so I have the form for table 1. To insert the 'table 2 Key' dowpdown, I need a dropdown with table 3 to filter selection for table 2. Eg. a simple "Province", "City" for Example.
So table 1 is User Address. (Main form)

Table 3 is Province. (dropdown 1)

Table 2 is City. (dropdown 2)
So City is Related to Province and Address; but address is not related to Province only to City. The only way I have been able to do this is with custom code, but PHPrunner reformats and changes the custom HTML each time it saves and reloads the project (another thing I need resolved).
So I don't understand why when I try to put (Dropdown 2) to be dependent on (Dropdown 1), "dropdown 1" doesn't appear in the "Category Control" list.

can you not use the dependant dropdown feature in the page where you set up the dropdown?

I did it many times without any problem.

You should check database structure for 'foreign keys'.
Here is an example:

It works!
Best Regards,

Mustafa

Your database design is incorrect. Your address table doesn't need a ProviceID this relation is captured in the City Table. With your design you can have City A linked to Province B, and Address C, linked to City A and Province D. (Eg. An address is now linked to two different provinces.).
Try doing it without ProvinceID in the Address Table. Doesn't work for me.
Kamil

I did it many times without any problem.