I'm not sure if that's feasible. There will be many items per box and many boxes per shipment.
--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:
>
> Hi John,
>
> Do you enter a shipped date when the materials have
> been shipped?
> If so then you can find the items waiting to be
> shipped by the absence of a shipped date.
>
> Regards, Clive.
>
> --- In MS_Access_Professionals@yahoogroups.com, John S Moss <jlinux@> wrote:
> >
> > 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