IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New We're not disagreeing here.
You're just using more words than I did. It wasn't clear from box's original post that his tables were in what you call a "master-detail" relationship. It was Norm who first assumed that.

Many fears are born of stupidity and ignorance -
Which you should be feeding with rumour and generalisation.
BOfH, 2002 "Episode" 10
New Ah... *that* "assumption"! :-)
Bobby B writes:
It wasn't clear from box's original post that his tables were in what you call a "master-detail" relationship. It was Norm who first assumed that.
Well, we actually know (now) that they *aren't* in a "master-detail" relationship, if by that you mean they'd have to have referential integrity constraints defined on them...

But on the other hand, they *are* in a "master-detail" relationship in the sense that that's how they're being used in BOx's query (if I understood it correctly); they are *being* "related" by the JOIN in the query.

At least the latter of my two paragraphs/sentences above is no assumption, on Norm's or anyone else's part.

And that the latter *should* (as in, "ought to") imply the former is also more of a reasoned opinion than an assumption. :-)


   [link|mailto:MyUserId@MyISP.CountryCode|Christian R. Conrad]
(I live in Finland, and my e-mail in-box is at the Saunalahti company.)
Your lies are of Microsoftian Scale and boring to boot. Your 'depression' may be the closest you ever come to recognizing truth: you have no 'inferiority complex', you are inferior - and something inside you recognizes this. - [link|http://z.iwethey.org/forums/render/content/show?contentid=71575|Ashton Brown]
     Have an Access problem - (boxley) - (34)
         The SQL is correct. - (tseliot) - (5)
             run toy data - (tablizer)
             how would I TRIM the above statement? - (boxley) - (3)
                 Try this: - (orion) - (2)
                     your update ran OK, thanks Norm but - (boxley) - (1)
                         Access relationships - (orion)
         Could be a relationship problem - (orion) - (1)
             only relationship, single user -NT - (boxley)
         Well the documentation is misleading? :-) - (ChrisR) - (2)
             the cut and paste was correct - (boxley) - (1)
                 I've changed it in my example - (orion)
         Is "field indexed *with duplicates allowed*" on BOTH tables? - (CRConrad) - (22)
             Re: Is "field indexed *with duplicates allowed*" on BOTH tab - (orion) - (19)
                 The only primary key is on the master table - (boxley) - (2)
                     Re: The only primary key is on the master table - (orion) - (1)
                         the only link is the serial fields - (boxley)
                 That is a major assumption on your part - (tseliot) - (15)
                     Actually, for oce Norm is far more right than wrong; you... - (CRConrad) - (2)
                         We're not disagreeing here. - (tseliot) - (1)
                             Ah... *that* "assumption"! :-) - (CRConrad)
                     ALL tables need PK's. - (mmoffitt) - (11)
                         Sorry; What's an "sp"? - (tseliot) - (2)
                             Probably 'Stored Procedures'.... - (ChrisR) - (1)
                                 In Access they are "Queries" - (orion)
                         Are you disagreeing with me? I can't tell. - (tseliot) - (7)
                             Dunno if I disagree. - (mmoffitt) - (6)
                                 Toy and scale are not the issues. - (tseliot) - (5)
                                     Then you don't need a thirty-line table at all... - (CRConrad) - (2)
                                         Thank you. -NT - (mmoffitt)
                                         Should I answer? - (FuManChu)
                                     But, but, a tool of any value has a serial number and they.. - (a6l6e6x) - (1)
                                         In this particular case - (FuManChu)
             Started with no index on either field - (boxley) - (1)
                 It's probably not a factor in your problem... - (tseliot)

Could be fun to watch if the chairs aren't bolted down.
106 ms