UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
3 Pages V < 1 2 3  (Go to first unread post)
   Reply to this topicStart new topic
> Relate Order Numbers On A Form And Display In A Listbox, Access 2016    
 
   
moze
post Mar 2 2018, 03:52 PM
Post#41



Posts: 22
Joined: 8-January 18



theDBguy,

I believe everything looks correct other than 5-6 and 6-5 should also appear in the result set
Go to the top of the page
 
theDBguy
post Mar 2 2018, 04:35 PM
Post#42


Access Wiki and Forums Moderator
Posts: 73,269
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Is it because 6 is related to 4 and 4 is related to 1 and 1 is related to 2 and 2 is related to 5?

Hence, 6 should be related to 5. Correct?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
moze
post Mar 5 2018, 10:22 AM
Post#43



Posts: 22
Joined: 8-January 18



Exactly!
Go to the top of the page
 
moze
post Mar 8 2018, 10:36 AM
Post#44



Posts: 22
Joined: 8-January 18



theDBguy,

Would you mind if I took a look at the query so far and played around with it on my end?
Go to the top of the page
 
theDBguy
post Mar 8 2018, 11:26 AM
Post#45


Access Wiki and Forums Moderator
Posts: 73,269
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Guess what? Our company decided to push the Win 10 upgrade to our machines and I forgot to make a backup copy of the file, so I will have to start over.

I'll post it here if I get a chance to do it today.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
moze
post Mar 8 2018, 02:20 PM
Post#46



Posts: 22
Joined: 8-January 18



That would be great!

I apologize for the inconvenience.
Go to the top of the page
 
theDBguy
post Mar 8 2018, 03:04 PM
Post#47


Access Wiki and Forums Moderator
Posts: 73,269
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Attached was one approach I was trying to play with. The other approach I was thinking of trying was to use a Cartesian Query.

Attached File(s)
Attached File  Orders.zip ( 27.52K )Number of downloads: 5
 

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
moze
post Mar 9 2018, 02:59 PM
Post#48



Posts: 22
Joined: 8-January 18



The approach you took from post #38 was almost perfect except for the missing relationship between 5-6 and 6-5.
Go to the top of the page
 
theDBguy
post Mar 9 2018, 03:28 PM
Post#49


Access Wiki and Forums Moderator
Posts: 73,269
Joined: 19-June 07
From: SunnySandyEggo


Without my old file, I can't remember which approach it was. I think maybe it was the Cartesian Product approach.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
theDBguy
post Mar 9 2018, 03:33 PM
Post#50


Access Wiki and Forums Moderator
Posts: 73,269
Joined: 19-June 07
From: SunnySandyEggo


Hi,

I modified the table to have the same records as I had in Post #38 and attached it here. Check out the result of Query4.

PS. I don't think I used the same approach this time as the last time when I posted those images, but the result is the same.

Hope it helps...

Attached File(s)
Attached File  Orders.zip ( 22.71K )Number of downloads: 2
 

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
moze
post Mar 9 2018, 03:57 PM
Post#51



Posts: 22
Joined: 8-January 18



I added 7 to the table and related 8 and the query produced 7-8 and 8-7 which is perfect because it didn't relate them to any others except each other. So now the only thing missing is the 5-6 and 6-5
Go to the top of the page
 
moze
post Mar 13 2018, 12:08 PM
Post#52



Posts: 22
Joined: 8-January 18



Is there a way to get those same results from only 1 query? Or do the queries need to be setup the way they are?
Go to the top of the page
 
theDBguy
post Mar 13 2018, 12:17 PM
Post#53


Access Wiki and Forums Moderator
Posts: 73,269
Joined: 19-June 07
From: SunnySandyEggo


You can combine all those queries into one, just like Query4 is a combination of Query0 and Query3. So, if I want to get rid of Query0 and Query3, I just need to embed their SQL statements into Query4.

Hope it helps...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
moze
post Mar 13 2018, 01:26 PM
Post#54



Posts: 22
Joined: 8-January 18



Okay, great. Any luck with the 5-6 6-5 relationships?
Go to the top of the page
 
theDBguy
post Mar 13 2018, 01:46 PM
Post#55


Access Wiki and Forums Moderator
Posts: 73,269
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Sorry, no. I haven't had a chance to get back to it yet. Been busy with company Windows and Office upgrades. Lots of issues with all users...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
theDBguy
post Mar 24 2018, 09:52 AM
Post#56


Access Wiki and Forums Moderator
Posts: 73,269
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Sorry for the delay, we're still dealing with issues on the Windows and Office upgrades.

Attached is the other approach I was talking about using a Cartesian Product.

Please test it out and let us know if it's anywhere closer than the other approach or not.

Cheers!

Attached File(s)
Attached File  Orders.zip ( 20.08K )Number of downloads: 3
 

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
3 Pages V < 1 2 3


Custom Search
RSSSearch   Top   Lo-Fi    25th September 2018 - 12:07 AM