John-
Then you should be able to discern the ship date by following the relationship
from shipping to manifest to items.
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@yahoogroups.com] On Behalf Of John S Moss
Sent: Saturday, November 26, 2011 9:20 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Staging Table
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]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar