It's not directly related. I have a Items table that would hold
everything that has been shipped. I have a one to many relationship from
that to a Manifest table since there will be many items on each
Manifest. The Manifest table has a one to many with the shipping table,
since there will be manifests per shipment.
On 11/26/2011 9:21 AM, John Viescas wrote:
>
> John-
>
> How are you relating records in the Shipping table to the items
> shipped? If
> there's a link, then the date in the row in the Shipping table gives
> you what
> you need.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>] On Behalf Of John
> S Moss
> Sent: Saturday, November 26, 2011 3:05 PM
> To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: Re: [MS_AccessPros] Re: Staging Table
>
> So have Date field for each item? That seems like an awful lot of the
> same dates to be stored. That field would have to be auto-populated
> until the user is done with the batch of material. Also, the Date
> Shipped needs to be on the Manifest and associated with the Shipping,
> Tracking, and Receipt numbers. That's why I had a separate Shipping
> Table and why I was thinking of using a separate staging table for
> materials being processed for shipping.
>
> On 11/25/2011 3:10 PM, Clive wrote:
> >
> > Hi John,
> >
> > You wrote: "I'm using one table to hold all the
> > materials shipped or waiting to be shipped."
> >
> > You can get the 'items waiting to shipped' by using
> > a Query and filtering on,
> > Where IsNull(tShipped.ShippedDate)
> > If you don't have a ShippedDate then they must be
> > waiting.
> >
> > Hope that helps.
> >
> > Regards, Clive.
> >
> > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.com>, "yshopper"
> > <jlinux@...> wrote:
> > >
> > > 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
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.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
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.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
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.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
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > <mailto:MS_Access_Professionals%40yahoogroups.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
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar