I posted a few days ago "Database Design Help". I have most of it set,
but there's one sticking point I need to resolve. I'm using one table to
hold all the materials shipped or waiting to be shipped. I was thinking
of using a Check-box to indicate what items were waiting to be shipped,
but that's a lot to remember to enter into the form for the end user.
I'm thinking of a Staging table to hold the items waiting to be shipped
and then Appending that data to the main table. I need to run a Report
for a shipping manifest before Appending. I would like two buttons that
will make it easier for the user to do the job.
Is it possible to run a Report from a button? Any tips appreciated.
Will an Append query just copy the data to the other table or can you
tell it to append and delete the data in the Staging table?
Thanks so much for all the previous help and any to come
John
Tidak ada komentar:
Posting Komentar