Ahhh yes Gloria, the cruelest cut of all for a new Access developer
is knowing Excel.
So, start at the basics for us.
- What is your database about (we've seen them all before)
- What are your main data groups (ie Customers, Stock, Orders)
- What is the job you have set out to do (ie maling list, stock
inventory, sales records etc)
See how we go from there
\Brett
At 01:16 25/08/06, you wrote:
>Brett,
>
>I did respond and outline what it was I wanted to do, that is why I
>asked again yesterday. Maybe my problem is the language in Access.
>I am so used to using Excel.
>
>If you need me to outline by business case again I will.
>
>Gloria
>
>--- In ms_access@yahoogroups.com, Brett Collings <[EMAIL PROTECTED]> wrote:
> >
> > Well to be honest, you tell us that you want to merge the products
> > into your master table and I have to say that doesn't sound right
>at
> > all. That's why we were asking you to outline your data and what
>the
> > business case is.
> >
> > Combining your data is "a piece of cake" but I really suspect that
> > it's not the way you think ... but I can't be sure of that until we
> > get an idea of the detailed stuff. Part of what this questioning
>is
> > about is to ensure that you don't build a non-normalized database
> > that will always cause issues as you continue to develop it.
> >
> > Brett
> >
> >
> >
> > At 06:43 24/08/06, you wrote:
> >
> > >I still haven't heard from anyone about this problem. Can anyone
> > >help me please?
> > >
> > >G.
> > >
> > >--- In ms_access@yahoogroups.com, "gcosta1010" <gcosta1010@> wrote:
> > > >
> > > > Brett,
> > > >
> > > > I am answering your questions below within your message.
> > > >
> > > > G.
> > > > --- In ms_access@yahoogroups.com, Brett Collings <bac@> wrote:
> > > > >
> > > > > G,
> > > > >
> > > > > This is really a piece of cake, we just need to reorganise the
> > > > > approach to it. As I understand it
> > > > >
> > > > > - tblMaster has customer records
> > > > > - tblProduct has a mixture of customerID's and Products
> > > > >
> > > > > The questions ...
> > > > > - What is the structure (fields) of tblMaster?
> > > > There are probably 12 fields in the Master, cust ID, Cust Name,
> > > > address, email, website..etc.
> > > >
> > > > > - What is the structure (fields( of tblProducts?
> > > > This table has cust ID, Cust Name, Product 1 (with yes or no),
> > > > Product 2 & 3 with same yes no answer.
> > > >
> > > > > - Is there more than one Product per customer in tblProducts?
> > > > Answered above.
> > > >
> > > > > - Are the other 16,500 records of 'old' customers?
> > > > The Master has the top 500 Customer, the other 16,500 I do not
>need
> > > >
> > > > > - What do you want to *do* with the information (please don't
> > >tell
> > > > us how you want to do it, just what)
> > > > I want to merge the products of the 500 cust into my Master.
> > > >
> > > > > What you do *not* want to do ...
> > > > > - Add the product code to your tblMaster YES
> > > > > - Have Customer information in both table except CustomerID
>YES
> > > >
> > > > I have added the three product columns to my Master to be ready
>to
> > > > merge the products into it from the Products table.
> > > >
> > > > You say this is a piece of cake, not for me it isn't. I hope
>this
> > > > helps clear up what I need to do. Thanks for your help.
> > > >
> > > > > So you can see why a little more info on your tables and what
>is
> > >in
> > > > > them will be useful
> > > > >
> > > > > Brett
> > > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >--
> > >No virus found in this incoming message.
> > >Checked by AVG Free Edition.
> > >Version: 7.1.405 / Virus Database: 268.11.3/423 - Release Date:
>18/08/06
> >
> >
> > --
> > No virus found in this outgoing message.
> > Checked by AVG Free Edition.
> > Version: 7.1.405 / Virus Database: 268.11.3/423 - Release Date:
>18/08/06
> >
>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>--
>Internal Virus Database is out-of-date.
>Checked by AVG Free Edition.
>Version: 7.1.405 / Virus Database: 268.11.3/423 - Release Date: 18/08/06
--
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.3/423 - Release Date: 18/08/06
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
