InfoPath Dev

Hi Everyone,

Is there a way to set a field(s) to the last record of a database.  Let's say that I have five database lines:

ID    Field1 

1       A
2       B
3       C

I want my field in infopath to query the database and pull the last value in the database, which in this case would be C.  Any ideas?

 Thanks in advance,

Bryan

Hi Bryan,

You can do it by changing the SQL command in the data connection wizard - click on the 'Edit SQL...' button in the data connection wizard, and enter the following command

Select TOP 1 * from <TableName> order by 'Field1' desc.