InfoPath Dev

Hi everyone, Does anyone know how to use the value from a checkbox on an InfoPath form as either 1 or 0 (ie True = 1, False = 0) I'm trying to do this in a repeating table, where the user will type in a value (eg an invoice amount) and then to the right of that set the check box = true if VAT should be added, or False if VAT is not ...

Hi Hilary, Yes it's just a plain old SQL data connection - You're exactly correct - I can use the sort options after pressing the Modify button. I've been working with InfoPath for about 4 months, but never pressed that button to see the sort options. (whoops, feel rather embarrassed now) I've wasted hours and hours on this ...

Hi everyone, I am using Infopath 2003, with VBScript where needed. I have created a form which is working well and which has several drop down lists which get their data from a SQL secondary data connection. As far as I can tell, there is no way to sort this drop down list(??) - it is always sorted using the Primary key field of the SQL table - ...