Have an Access problem - (boxley) - (34) - June 27, 2003, 11:40:35 AM EDT
         The SQL is correct. - (tseliot) - (5) - June 27, 2003, 12:49:43 PM EDT
             run toy data - (tablizer) - June 27, 2003, 01:32:51 PM EDT
             how would I TRIM the above statement? - (boxley) - (3) - June 27, 2003, 01:33:13 PM EDT
                 Try this: - (orion) - (2) - June 27, 2003, 01:51:48 PM EDT
                     your update ran OK, thanks Norm but - (boxley) - (1) - June 27, 2003, 02:18:14 PM EDT
                         Access relationships - (orion) - June 27, 2003, 05:18:27 PM EDT
         Could be a relationship problem - (orion) - (1) - June 27, 2003, 01:37:13 PM EDT
             only relationship, single user -NT - (boxley) - June 27, 2003, 01:41:02 PM EDT
         Well the documentation is misleading? :-) - (ChrisR) - (2) - June 27, 2003, 02:27:15 PM EDT
             the cut and paste was correct - (boxley) - (1) - June 27, 2003, 04:55:32 PM EDT
                 I've changed it in my example - (orion) - June 27, 2003, 05:21:09 PM EDT
         Is "field indexed *with duplicates allowed*" on BOTH tables? - (CRConrad) - (22) - June 27, 2003, 05:52:26 PM EDT
             Re: Is "field indexed *with duplicates allowed*" on BOTH tab - (orion) - (19) - June 27, 2003, 06:41:35 PM EDT
                 The only primary key is on the master table - (boxley) - (2) - June 27, 2003, 07:20:48 PM EDT
                     Re: The only primary key is on the master table - (orion) - (1) - June 27, 2003, 08:22:20 PM EDT
                         the only link is the serial fields - (boxley) - June 27, 2003, 09:35:46 PM EDT
                 That is a major assumption on your part - (tseliot) - (15) - June 27, 2003, 09:35:31 PM EDT
                     Actually, for oce Norm is far more right than wrong; you... - (CRConrad) - (2) - June 28, 2003, 09:30:20 AM EDT
                         We're not disagreeing here. - (tseliot) - (1) - June 28, 2003, 01:13:30 PM EDT
                             Ah... *that* "assumption"! :-) - (CRConrad) - June 28, 2003, 02:58:36 PM EDT
                     ALL tables need PK's. - (mmoffitt) - (11) - June 30, 2003, 11:40:08 PM EDT
                         Sorry; What's an "sp"? - (tseliot) - (2) - July 1, 2003, 10:31:18 AM EDT
                             Probably 'Stored Procedures'.... - (ChrisR) - (1) - July 1, 2003, 10:36:51 AM EDT
                                 In Access they are "Queries" - (orion) - July 1, 2003, 12:32:23 PM EDT
                         Are you disagreeing with me? I can't tell. - (tseliot) - (7) - July 1, 2003, 04:18:35 PM EDT
                             Dunno if I disagree. - (mmoffitt) - (6) - July 3, 2003, 11:23:33 AM EDT
                                 Toy and scale are not the issues. - (tseliot) - (5) - July 3, 2003, 02:10:46 PM EDT
                                     Then you don't need a thirty-line table at all... - (CRConrad) - (2) - July 3, 2003, 03:51:15 PM EDT
                                         Thank you. -NT - (mmoffitt) - July 3, 2003, 10:56:12 PM EDT
                                         Should I answer? - (FuManChu) - July 4, 2003, 01:18:46 PM EDT
                                     But, but, a tool of any value has a serial number and they.. - (a6l6e6x) - (1) - July 3, 2003, 09:56:56 PM EDT
                                         In this particular case - (FuManChu) - July 4, 2003, 01:24:29 PM EDT
             Started with no index on either field - (boxley) - (1) - June 27, 2003, 07:15:57 PM EDT
                 It's probably not a factor in your problem... - (tseliot) - June 27, 2003, 09:37:44 PM EDT