Search results

on a form, the latest shipment info is collected to the Transactions Table...item id, latest price, quantity, ps#, etc. At the end of the info gathering line, would like a command button to take the info from the form and update a second Inventory file. SQL UPDATE works as a stand alone, but...

Thank you, Pat. No lesson nor reference even hinted at this. I'll give it a whirl tonight.

I need a continuity field...transaction number..that can be both a parent and child key. Would like to create this upon accessing a new record / row. Don't laugh, I'm a beginner with Access.

Really new to Access. Did a lot of work with the old Borland dBase. Liked it's direct approach to getting a solution. Joining the 21st century and Access is a bit of a struggle, so am needing a lot of help. Thanks