I have a form that has two tables, I am attempting to populate the seconed table with the result if lookup rules matched in first table.
First table has two dropdown menu, I fill the first dropdown menu from data source table's first column, then make another lookup rule to fill the seconed dropdown menu from second column in the same data source table if first dropdown menu match with first column in data source table, then create a Lookup Rule to fill all columns in the seconed table in form from other columns in data source table if the first dropdown menu and seconed dropdown menu matches with the first column and seconed column in data source table.
but the problem is the checkbox option "as new rows" in lookup not active to populate data in side table rows.
any help please?