Hi,

I'am new to SQL and .net.

I need to generate and retreive an unique Transaction_id (int field) for different offices; each office would start off with say 1000000001 for Office One and Office Two would start off with 2000000001; etc. The field would be in the Office Table, one row for each office.

Not sure how to update a row in a table with an int field and add +1 to it and return it to VB .net. I understand that ADO.Net is disjoined. In VFP I would simply retrieve the record, lock it, and if locked then update the field with id+1 and I would have the number I needed.

What would I need to do to accomplish this in VB .net project? I need detail because I'am not very versed in SQL and Vb.net. I learning more every day.