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,951
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?
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,951
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.
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,951
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
 
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,951
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.
Go to the top of the page
 
theDBguy
post Mar 9 2018, 03:33 PM
Post#50


Access Wiki and Forums Moderator
Posts: 73,951
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
 
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,951
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...
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,951
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...
Go to the top of the page
 
theDBguy
post Mar 24 2018, 09:52 AM
Post#56


Access Wiki and Forums Moderator
Posts: 73,951
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
 
Go to the top of the page
 
3 Pages V < 1 2 3


Custom Search


RSSSearch   Top   Lo-Fi    15th December 2018 - 06:19 AM