Could be a relationship problem

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

Welcome to IWETHEY!

Post #107,560 by orion 6/27/03 1:37:13 PM Reply	Could be a relationship problem Go to the tools menu, select Relationships, is there any other indexes being set between those two tables? If so, this could be part of the problem. "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]
Post #107,561 by boxley 6/27/03 1:41:02 PM Reply	only relationship, single user will work for cash and other incentives [link\|http://home.tampabay.rr.com/boxley/resume/Resume.html\|skill set] questions, help? [link\|mailto:pappas@catholic.org\|email pappas at catholic.org] As the Poets have mournfully sung. Death takes the innocent young, The rolling in money, the screamingly funny, And those who are very well hung. W.H. Auden

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

Same thing we do every night, Pinky... try to take over the WORLD!
163 ms