Hi. I have a similar problem to James, and the Potemkine's solution sounds perfect.
I'm new to Infopath/Sharepoint and i'm looking for a book or website with programming syntax, can anyone recommend a good one?. I can do a bit of VBa, so I'm happy with programming logic but it's the basics of Infopath's syntax ...