Field to display last record in table

[johnpinter]

I am new to Infopath and SQL programming.

I have a form that is created from a SQL database. This database has an
autonumber field set as primary. However, I can not display anything other
than 1 or empty using the last(), count() or max().

Can someone please tell me how to reference the last record in the table? I
want to be able to pull the last record in the table, increment it by 1 and
submit the new record/number back to the table once the form is complete.

Thanks in advance.