Distinct Query + show other fields (1 Viewer)

chineloogbonna

Registered User.
Local time
Today, 11:22
Joined
Jul 30, 2018
Messages
65
Hello,
I am trying to figure out how to run a Distinct Query for a particular fields BUT also show the other fields.

Basically, I have a listbox that populates a query where fields 1 to 5 are the same but fields 6 to 10 may have different values.

I would like my listbox to show only Distinct records for fields 1 to 5 but I would like the query to populate all fields 1 to 10 so I may use the column values in textboxes on the form.

Not sure if this is doable with a query or if I have to create 2 tables and do a JOIN?

Thank you!
 

isladogs

MVP / VIP
Local time
Today, 17:22
Joined
Jan 14, 2017
Messages
18,186
If fields 6-10 have different values you will get repeated rows for fields 1-5.
It may be better to have 2 listboxes with the first showing fields 1-5.
When a record is selected from the first listbox, the second can show all related records in fields 6-10
 

chineloogbonna

Registered User.
Local time
Today, 11:22
Joined
Jul 30, 2018
Messages
65
If the 1st listbox has a distinct query for first 5, how do I create a listbox to show related fields in listbox2?

Thanks!
 

isladogs

MVP / VIP
Local time
Today, 17:22
Joined
Jan 14, 2017
Messages
18,186
Similar to cascading combobox idea - filter the row source for the 2nd listbox based on the bound field selected value in the first listbox.
That field needs to be in the 2nd listbox as well but can be hidden(width = 0)
 

Users who are viewing this thread

Top Bottom