I have a quick query regarding Infopath 2010 submitting data into a MOSS 2007 form library. This is the first time I'm trying to build a form using 2010. Normally in 2007, when cerating the submission I'd query the form library to get the ID & then use @max(ID)+1 to get the next available number which I'd then use in the name of the form, however, in Infopath 2010, you don't appear to be able to use the ID field in formula as it doesn't appear in the list of avaialble fields in the data connection. I considered using a calculated field which equals the ID, but calculated fields aren't usable either.
Has anyone else seen this or is it just my installation? has anyone worked around this?
Thanks in advance.
View Complete Post