hymnal and song db list box duplicate records

[mikevds]

I have the fields set for the songs field, from the hymnal songinfo table which includes name of song, hymnal number, author and key etc.

The only thing is their is more then one hymnal associated with each song so it displays duplicate values for all of those songs when I program the list box.

If I do a find unmatched query the records don't come up.

Would I have to add a name of song number so it would only drill from each hymnal so then each songs wouldn't come up associated with each hymnal.
Like it would display 4 records of Joy to the World, because it is in associated with 4 hymnals related to an author.

The same thing is true for the authyor and key, list box I am trying to link to the subform, more then one author and key is associated with one song so it likes to display all of those records, like James Montgomery 4 times becaus it is in 4 hymnals

So does anyone know a way around this, unless I set up in the hymnal table song number like number 1 joy to the world, 2 Away in a Manger etc.

The samething with the author and key number 1, james montgomery, 2, Luther etc.

Please can someone get back on this.

Regards.

Michael Van Der STad

 

[Kafrin]

Can you just do a Group By on the 3 fields in the recordsource query?

Alternatively you need a query with SQL that starts with SELECT DISTINCTROW instead of just SELECT.

 

[Stacey]

Re: hymnal form combo box duplicate values

Try building a query against the hymnal songinfo table that only includes the song. Then use the Totals/Group By to only return 1 row for each song in the query. Set your row source type on the combo box to Table/Query and choose the query you built as the row source. The songs should only display once in the drop down.