When using MS InfoPath 2010 to enter data into a SharePoint database, I want to be able to display in the InfoPath form in a field called SBSR#, the text "SBSR" plus the next available ID number from the SharePoint database ID field. How can I make that happen? What formula will make that happen in the InfoPath Text Box Properties dialog box? Everything I've tried so far produces NaN because the item hasn't been written to the SharePoint database yet.
I appreciate any ideas.