R
Rich S.
Hello Access Folk,
I am working on a purchase order app for my company and I am stuck on a
detail.
The table structure is pretty straight foward (purchaseID, description,
vendor, quantity, cost, PO) with PO set with default value 9999999 until it
gets updated and assigned a PO number. At completetion of the PO, user hits
button that calls update query, searches for any 9999999 PO and assigned it
the next sequential value. Or at least that is the plan.
My problem is how do I get it to only update the unassigned for that
specific purchase order. My best guess is to tie it into the vendor field,
but not sure on the query grammar to pull it off.
Rich S.
I am working on a purchase order app for my company and I am stuck on a
detail.
The table structure is pretty straight foward (purchaseID, description,
vendor, quantity, cost, PO) with PO set with default value 9999999 until it
gets updated and assigned a PO number. At completetion of the PO, user hits
button that calls update query, searches for any 9999999 PO and assigned it
the next sequential value. Or at least that is the plan.
My problem is how do I get it to only update the unassigned for that
specific purchase order. My best guess is to tie it into the vendor field,
but not sure on the query grammar to pull it off.
Rich S.