Hi David
The form is running on my local dev machine and links to custom tables plus Indoo Grid.
I think I've found the problem, though:
My question 'Options' is a checkbox group with options derived using SELECT * WHERE ProductId = $(ProductId). This works correctly when a value is manually inserted into ProductId.
When I load data into the form (i.e. form is in "Edit" mode) all the form questions are correctly populated - including ProductId. However, SELECT * WHERE ProductId = $(ProductId) query returns a null. If I change this to SELECT * WHERE ProductId = 1 it displays the correct options for ProductId 1. It also works if I pass the ProductId as a query string variable.
So my challenge is: how do I set the question sql options to different sql statements depending on the mode of the form?
David