Re: I'm just getting started an I have some questions on tables.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

If you follow link, in prev.post, then check out 64,65,57,68, and their
various links, it shows you how to handle clients with multiple addresses
and multiple contacts.
I don't see it making any difference, other than to rates as to what type of
customer or what type of installation. You can in any case use a 'customer
type' field and 'installation type' which can in turn be linked to various
rates tbls.

"Marc" <mcneer(N_O-S_P_A_M)@mindspring.com> wrote in message
news:v6vee.4412$7F4.1127@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> I'm a low voltage contractor i.e. phone, cable, networking, distributed
> audio, home theater, secuirty, home automation, lighting contol, central
> vacuum, intercom, CCTV and access control. We pre-wire, sell and install
> all the equipment. So we have applications across the board - commercial,
> residential - new construction and retro. Right now I'm using a workbook
in
> Excel which works - kind of.
> Marc
>
> "DL" <dl@spoofmail> wrote in message
> news:OGU79jaUFHA.3544@xxxxxxxxxxxxxxxxxxxxxxx
> > It may be helpfull if you gave your (Bus.) position in all this.
> > eg The Architect who may be contracted by the builder (customer) or may
be
> > contracted by the customer ( Individual who then contracts the builder)
> > We could then more easily follow the structure required.
> > You might also look here,
> > http://www.databaseanswers.org/data_models/index.htm
> > there maybe something that helps
> >
> > "Marc" <mcneer(N_O-S_P_A_M)@mindspring.com> wrote in message
> > news:LJsee.5632$V01.2714@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > > Part of it's a PIM but the other part is a way of generating quotes,
> scope
> > > of work, invoices (exported to QuickBooks) and possible inventory. I
> deal
> > > with builders, end user and commercial customers that have different
> price
> > > structures. In some cases the builder (company) becomes a customer
(end
> > > user) when they build their own homes. The builders often have their
> > > infra-structure - purchasing, AP, superintendents etc. that have to be
> > > referenced to the builder and have different locatyions. In some
cases
> > the
> > > superintendent's office is in their home with completely different
> contact
> > > information that the office and I need to send information to both.
> This
> > is
> > > why I see a need for both tables - tell me if I'm wrong. Eventually
we
> > > want to move the quote part on-line for the builders clients to use.
> > >
> > > Marc
> > >
> > > "DL" <dl@spoofmail> wrote in message
> > > news:e1XyONZUFHA.628@xxxxxxxxxxxxxxxxxxxxxxx
> > > > What you need/require seems to have changed substantialy, from a
> > 'simple'
> > > > contacts db to nearly a full blown PIM. Perhaps you might be advised
> to
> > > > write down everything you require first.
> > > > Then layout the tables on paper, you only need show main/index
fields,
> > > that
> > > > way you can see what is required and their relationships. Only then
> > would
> > > > you fire up Access
> > > >
> > > > "Marc" <mcneer(N_O-S_P_A_M)@mindspring.com> wrote in message
> > > > news:%aqee.4292$7F4.923@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > > > > I understand will there be a problem with the companies having
> > contacts
> > > > all
> > > > > in the same table?
> > > > >
> > > > > Marc
> > > > >
> > > > > "Mike Revis" <mike@xxxxxxxxxxxxxxxxx> wrote in message
> > > > > news:117k6im680fnt82@xxxxxxxxxxxxxxxxxxxxx
> > > > > > Just a thought here but how about treating both companies and
> > > > individuals
> > > > > as
> > > > > > the same type of entity. i.e. "customers" or "people and
companies
> I
> > > > want
> > > > > to
> > > > > > keep track of".
> > > > > > You could then have one table for "customers" and have a field
for
> > > > "type"
> > > > > in
> > > > > > which you could select either business or individual. Your
contact
> > > table
> > > > > > would then contain the contacts at either the company or
> individual.
> > > > > > If the type and amount of contact data you are collecting for
> > > companies
> > > > is
> > > > > > greatly different from the contact data collected for
individuals
> > you
> > > > > should
> > > > > > have a separate contact table for companies and individuals with
a
> > > > > separate
> > > > > > data entry form for each. Which contact form to open could be
> > > determined
> > > > > by
> > > > > > the entry in the "type" field.
> > > > > >
> > > > > > Mike
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Marc" <mcneer(N_O-S_P_A_M)@mindspring.com> wrote in message
> > > > > > news:ytaee.5225$V01.4442@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > > > > > > I deal with both companies and end users and I'm trying to
> figure
> > > out
> > > > > how
> > > > > > to
> > > > > > > set up the contact table. My plan was to set one table for
> > > companies
> > > > > and
> > > > > > > have contact entries as a sub form and another form for
contacts
> > > with
> > > > > > > individuals but both the company contact sub form and the
> > individual
> > > > > form
> > > > > > > would link to the same table? My reasoning is that I may have
> > many
> > > > > > contacts
> > > > > > > to one company but have individuals that contacts normally at
> most
> > > > would
> > > > > > be
> > > > > > > "domestic partners"and their family members and I want to
track
> > > > contacts
> > > > > > > whether it's email, phone calls, letters and more. The first
> > > question
> > > > > on
> > > > > > my
> > > > > > > form would be which kind of contact would I be working with
and
> > > bring
> > > > up
> > > > > > the
> > > > > > > correct form. I know that this will be the first of many
> > questions.
> > > > > > >
> > > > > > > Marc
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


.

Relevant Pages

  • Re: General Consulting Advice Urgently Needed
    ... Some consultants - or the consulting bosses who hire them out, ... wants a contractor who will perform at least as well as someone he ... The customer wants a desktop application that will run on ... Struts 2 be better? ...
    (comp.lang.java.programmer)
  • Re: Working with incompetent adaists / unsafe typing war story
    ... Safety carefully designed and implemented is insufficient for the ... "Build me a house, and put it right there please." ... Builder: "What are the requirements of this house? ... Customer: "What is this? ...
    (comp.lang.ada)
  • Re: normal business practice
    ... The order was placed through the UK distributor. ... re-assuring if the details being passed onto the builder were also ... such an undiplomatic attitude to a customer, ... A contract for a customised design and build project like a boat should be ...
    (uk.rec.sailing)
  • Re: getting estimates for new windows
    ... the all knowing contractor know what will make me happy... ... house. ... I had done the downstairs windows shortly after buying the ... or builder under contract for your new construction, ...
    (rec.pets.cats.anecdotes)
  • Re: Gota love your insurance guy.... unless
    ... builder or general contractor and he wants to"spread the wealth" ... builder or general contractor, who has a much bigger exposure than you. ... It's a win-win situation for the builder and his insurance carrier. ...
    (alt.security.alarms)