Thanks John. That's what I thought.
On 11/26/2011 3:01 PM, John Viescas wrote:
>
> 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%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 9:20 PM
> To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.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%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.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>
> > <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>
> > > <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>
> > > <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>
> > > <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>
> > > <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>
> > > <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
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar