I am making a paper catalogue so house guests visiting can browse the catalogue, find a movie they want to watch, go over to the shelf it's on so they can load the physical disc into the player. The issue I'm having is when trying to sort filtered lists (genre - western for example) the box set movies get sorted into alphabetical order after the box set title. For example, "Duck, You Sucker" gets listed after "Once Upon a Time in the West" because it is in the "Sergio Leone Anthology", not after "Django", as it should for my collection.
When I run a report on the entire collection using the "Standard (show all records, sort by title)" option and the "Box Set Contents" option, the movies sort in the proper order. However, as stated earlier, adding a filter makes them sort as noted above.
Is there any way to make this work?