Distinct Query + show other fields

[chineloogbonna]

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]

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]

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]

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)

 

[chineloogbonna]

Got it, than you!