How to do dynamic dropdown list from relational database tables, when inserting a one table records

I have tables such as table1, table2, table3. table1 has foreign keys of table2 and table3, so i want to create insert database action and form to insert table1 data, for that i need to list table2 and table3 data in each separate dropdown list(select list) when choosing the item in each drop down list, ID’s will be inserted into table1 as foreign key. ex: category and news,

how to do this in wappler? im using wappler 2.1.5…

Community Page
Last updated: