I've changed it in my example

IWETHEY v. 0.3.0 | TODO

1,095 registered users | 1 active user | 3 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #107,591

by orion

6/27/03 5:21:09 PM

I've changed it in my example

I have created a database using the same names you have described in the query, all I have is serial_number in one, and serial in the other. No other column names. They are set as indexed with duplicates allowed. I am doing this to try and replicate the problem you are having. I am entering the data myself, bogus data, but data that works. Not the exact same as your database, but enough of it so I can get a better idea of what is going on.

"I wonder how much of this BS Corporations will continue to shallow before they start looking into alternatives to Microsoft software?" -[link|http://z.iwethey.org/forums/render/content/show?contentid=106839|Orion]

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

iwethey.org

Yow!
113 ms