I have a Shipment table with date shipped, tracking number, etc. That's related to the Manifest table - Many Manifests for each Shipment.
--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:
>
> Hi John,
>
> You must have some way of keeping track. You will need,
> at the very least, a Ship Date for a Shipment.
>
> You will probably need some sort of control on the
> filling and storing of boxes to keep track of the
> components that go in them.
>
> It's a bit like Production Control where you have to
> keep track of Components, Bills of Materials and
> Assemblies.
>
> Regards, Clive.
>
> --- In MS_Access_Professionals@yahoogroups.com, "yshopper" <jlinux@> wrote:
> >
> > 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