How to UPDATE queried results?

R

Reid

Greetings:

I have a simple form that queries on single field(Asset Tag) and
returns the details of the row for that Asset Tag.

I would like to be able to change one of the fields (RAM, harddrive,
etc.) and then update the database.

The query part works great, but I cannot figure out how to get the
update part working.

Is there an easy way to do this?

The database is SQL Server 2000.
The client is running InfoPath 2007.

Thanks,
Reid
 
A

Art

Thetable must have a primary key for updates to be allowed

Do you have a primary key set?
 
Top