Adding dynamic dropdowns to a DataAssist page
The records I'm trying to insert each have an associated category and each category has sub-categories linked to it. I've set them up as 2 tables in my database ok. DataAssist has generated the page and I have inserted records to the database fine with the specified category but I need dynamic dropdowns to make the sub-category list repopulate when the category is changed.
I thought I had this cracked but however I amend the DataAssist generated page I cannot add the "populate list from behavior" which is always grayed out.
I would really appreciate being pointed in the right direction, thanks!