Hi,
I was wondering if there is any way within DW by which we can probably access the value of a particular field when adding an Item, and using that value to run an SQL query to populate a Dropdown list or a radio button list. I know that we can run SQL commands to get some values, and I do use that quite a lot, but it would be really helpful if we could do the same for field values. So for eg, one of the fields in our Item is Country, and it is a dropdown list which gets values from a table called Countries within the database. The next field is another dropdown list called Destinations. Now, this loads all the Destinations within the system, but we only want it to display the Destinations for the Country selected above. We have another table which links Countries to Destinations so will use that to list the Destinations of the selected Country.
If you need any more explanation, I can give that.
Look forward to hearing from you.
Best Regards,
Yash.