How to create Dependent Dropdown List in Forms with data from different Tables

[keno0177]

there is main data table named MainData:

ID	Country	State
1	USA	NY
2	Egypt	Cairo
3	KSA	Jedda

I have tow tables :

1- Table named Countries

CID	Country
1	USA
2	KSA
3	Egypt

2- Table named States

SID	CID	State
1	1	NY
2	1	LA
3	1	CF
4	2	Jedda
5	2	Mekka
6	2	Reyad
7	3	Cairo
8	3	Giza
9	3	Alex

how to create Dropdown List in Form dependent each other tables

[Tommy62]

Ohne genau zu wissen, was sie möchten könnte dieses Video hilfreich sein: 2 Möglichkeiten zum automatischen Ausfüllen von Formularen 

[keno0177 · Accepted solution]

I figured out 😎

1- Country Table - Config

2- State Table - Config

3- City Table - Config

4- MainData Table - Config

5- State Column - Config

6- City Column - Config