Hello,
This is my first post here and fairly new to Infopath, please excuse if this question has been asked before.
I have a field that is linked to a team id and what I;d like to do (if possible) is to create a function in infopath which either queries the database for a current count of records or pulls the number from a query within the access database by team id and then uses that count number and increments it by one when submitting a new record in the form to generate a specific record id.
Any suggestions would be greatly appreciated.