Re: One-To-One Tables

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

I thought you were withdrawing from further response.

I remember seeing the posting you have copied here, but it isn't in this
thread.

"Steve" wrote:

Again, here is my response .........

Actually you don't have one-to-one relationships! You have a one-to-many
relationship between Agreements and Requirements. You have a one-to-many
relationship between Requirements and Certificates. You have a one-to-many
relationship between Requirements and Validation Checks. Your tables should
look like:
TblAgreement
AgreementID
<Agreement Fields>

TblRequirement
RequirementID
AgreementID
<Requirement Fields>

TblValidationCheck
ValidationCheckID
RequirementID
<Validation Check Fields>

This is just a basic outline since you gave no details about agreements,
requirements and validation checks. If you provide more detail, I will
expand upon the above.

Steve
santus@xxxxxxxx

"oldblindpew" <oldblindpew@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B87637B6-B9F8-4735-832C-265A3C3EDEE1@xxxxxxxxxxxxxxxx
Nope. Steve said I got three initial responses to my question, one from
Jerry, one from Steve and one from John. I see only Jerry's and John's.
--OBP

"Duane Hookom" wrote:

I think $teve was referring to an earlier thread from the same OP.

--
Duane Hookom
Microsoft Access MVP


"John W. Vinson" wrote:

On Wed, 26 Aug 2009 11:32:47 -0400, "Steve" <notmyemail@xxxxxxxxxxx>
wrote:

You got three initial responses, Jerry, myself (Steve) and John.

I think you may have propagation problems, Steve: your response did not
make
it to my server (and probably not to oldblindpew's either).

--

John W. Vinson [MVP]




.

Relevant Pages

  • Re: OT: Snits argument preserved - act 2
    ... Steve is spewing hate filled BS into CSMA. ... Which, strangely enough, is the same thing John was doing in the post ... ignoring Steve's trolling is not an effective response to it. ... As long as Snit uses my name in posts where he's lying I'm going to call ...
    (comp.sys.mac.advocacy)
  • Re: OT: Snits argument preserved - act 2
    ... stirring the pot and trolling in response to *nothing* other than his own ... newbies and lurkers know what Steve is up to. ... John for, in your view, poorly responding to Steve's outrageous ... John jumped right on attacking Steve for posts that ...
    (comp.sys.mac.advocacy)
  • Re: OT: Snits argument preserved - act 2
    ... Steve is spewing hate filled BS into CSMA. ... Which, strangely enough, is the same thing John was doing in the post ... ignoring Steve's trolling is not an effective response to it. ... John jumped right on attacking Steve for posts that ...
    (comp.sys.mac.advocacy)
  • Re: OT: Snits argument preserved - act 2
    ... Steve is spewing hate filled BS into CSMA. ... Which, strangely enough, is the same thing John was doing in the ... ignoring Steve's trolling is not an effective response to it. ... As long as Snit uses my name in posts where he's lying I'm going to ...
    (comp.sys.mac.advocacy)
  • Re: OT: Snits argument preserved - act 2
    ... Steve is spewing hate filled BS into CSMA. ... Which, strangely enough, is the same thing John was doing in the ... ignoring Steve's trolling is not an effective response to it. ... John jumped right on attacking Steve for posts ...
    (comp.sys.mac.advocacy)