Re: Query Me This -- two references to another tables field

Thank you for all your help, Steve -- I will go back and do it the way I
first conceived (glad to know my initial instincts weren't _all_ bad :-) and
stick all this stuff in the tblContacts.

Thanks again for your kind attention on a Saturday --
Carol




"Steve Schapel" <schapel@xxxxxxxxxxx> wrote in message
news:utnr%23FgeFHA.2736@xxxxxxxxxxxxxxxxxxxxxxx
> Carol,
>
> Opinions may vary on this. I am not sure why someone else has advised
> you the way they have. One-to-one relationships add complexity to the
> data structure, so there has to be a good reason to introduce this extra
> complexity. In my opinion, your database doesn't even begin to qualify.
> If it was mine, all of the information you listed would absolutely,
> definitely be in the tblContacts table, where you had it in the first
> place. You will be able to get it to work by having it in a separate
> table, but I wouldn't even think about it.
>
> --
> Steve Schapel, Microsoft Access MVP
>
> CS wrote:
> > We would only be interested in how they _initially_ were referred,
> > regardless of what their first contact with the organization was (so
there
> > would, in fact, only be one possible initial referral source), but we
would
> > want to know what their first contact with the organization was.
> >
> > I would say that about 50% of the contacts are NOT referred by someone
else
> > (they find the organization on their own), or, they are existing
contacts
> > from a flat-file DB that is being ported to Access, which did not
collect
> > this information (some of which are 6 - 7 years old) -- when the DB is
ready
> > to go, we will attempt to collect this original referral information for
as
> > many of our existing contacts as possible, but you know how people are
about
> > responding to a survey at times, so we may very well not get this
> > information. What is your opinion on that percentage of total contacts
(400
> > of about around 800 at this point, and growing quickly) in terms of
blanks
> > if all of this is tracked in the basic contact table?
> >
> > Also, we want to gather a number of different pieces of information
about
> > the referral, even if self-referred --
> > 1. Type of first contact with the organization
> > 2. Who referred them, if it is currently a contact in the DB
> > 3. How they found us, if there was no person referring them
> > 4. Date of first contact with organization
> > 5. Notes about the first contact
> >
> > I actually started out with all this in the tblContact, but removed it
and
> > began working with a separate table at the suggestion of someone in this
NG.
> > Since I am not yet truly adept at append, join, etc., I have erred
> > consistently on the side of more rather than less tables.
> >
> > Thanks again for your help,
> > Carol
> >


.

Relevant Pages

  • Re: Temp nym change 4 ACHILLES
    ... Who is the mouthy girlie you are referring to? ... If you are not referring to me than i appologize.I ... So in my opinion, by all means feel free to use ... is directed towards Carl. ...
    (alt.support.chronic-pain)
  • Re: Query Me This -- two references to another tables field
    ... One-to-one relationships add complexity to the data structure, so there has to be a good reason to introduce this extra complexity. ... In my opinion, your database doesn't even begin to qualify. ... Steve Schapel, Microsoft Access MVP ... if there was no person referring them ...
    (microsoft.public.access.gettingstarted)
  • Re: Poeple!!! what the?????? is going on????
    ... Well God knows you're entitled to your opinion. ... I'm not sure that's exactly what Rosie said at all Carol. ...
    (alt.med.fibromyalgia)
  • Re: No flag pin.. shame on you lol
    ... Can you cite the particular poll you're referring to Ken? ... Is your opinion of Barack Obama favorable, not favorable, undecided, or haven't you heard enough about Barack Obama yet to have an opinion? ... Is your opinion of John McCain favorable, not favorable, undecided, or haven’t you heard enough about John McCain yet to have an opinion?. ...
    (rec.music.gdead)
  • Re: Coastercon comments
    ... this is the one I was referring to. ... Regional events are definitely better than national. ... opinion. ... to assist in making a decision that could affect the lives of any ...
    (rec.roller-coaster)