Hi,
I have created a View in PhpMyAdmin based on a multi-table join query. The query and the view both return the expected data in PhpMyAdmin.
I'm tring to use the view as data source (source Table) in Chronoforms Read Data action to populate a dropdown on a page with no joy. I tired using a Read Data action with Relations (advanced Settings) but gave up as setting a three-table join had me scratching my head. So I reverted to my View (if only I can get it to work.
The View has 2 fields (product_id and product_name) required to populate the dropdown value and text.
The Option Data of the dropdown is set as {var:model_name.product_id} and {var:model_name.product_name} respectfully.
A Reload event of the dropdown reloads the page with the Read Data action which is in a separate page group.
Can't work out what I've left out.
I have created a View in PhpMyAdmin based on a multi-table join query. The query and the view both return the expected data in PhpMyAdmin.
I'm tring to use the view as data source (source Table) in Chronoforms Read Data action to populate a dropdown on a page with no joy. I tired using a Read Data action with Relations (advanced Settings) but gave up as setting a three-table join had me scratching my head. So I reverted to my View (if only I can get it to work.
The View has 2 fields (product_id and product_name) required to populate the dropdown value and text.
The Option Data of the dropdown is set as {var:model_name.product_id} and {var:model_name.product_name} respectfully.
A Reload event of the dropdown reloads the page with the Read Data action which is in a separate page group.
Can't work out what I've left out.