 | mvagh | | ..thanks for all the fish |
| Registered: June 5, 2007 |  Posts: 5 |
| | Posted: | | | | hi All,
I'm organising my DVD collection in those nice, practical 500 disc alu DJ suitcases. But, the sleeves in the cases are always numbered 1 thru 500. And that is a little cumbersome with my Collection number. Basically, I need a reset in the coll.number after every 500 discs, but keep my sorting of the suitcases.
I've tried many ways, but the bottom line is that I need a multiple sort (first on my "suitcase number", which I stored as a location, then on my collection number) or a filter on my suitcase number so I can filter them before printing.
Used to do a lot of SQL, so here is how it could be done in SQL:
SQL for the mult sort: SELECT * FROM COLLECTION ORDER BY SUITCASE, COLLECTION NUMBER
SQL for the filter solution: SELECT * FROM COLLECTION WHERE SUITCASE = <<some suitcase number>> ORDER BY COLLECTION NUMBER
I hope my question sounds a bit logical to somebody... | | | regards
Gertie |
|
| Registered: March 15, 2007 | Reputation:  |  Posts: 5,459 |
| | Posted: | | | | I have to admit, your question is way too technical for me - but did you know there were two elements to disc location?
You could put suitcase number in location, and disc number in slot - and that would allow you to restart your numbering.
The downside is that it all has to be done manually (or so I believe).
Then if you display the disc location column in your collection, you should be able to sort it correctly. |
|
| Registered: March 14, 2007 |  Posts: 630 |
| | Posted: | | | | Basically it sounds like you are attempting to make the collection number do what the location and slot fields are designed to handle.
The location/slot fields also support multiple discs per collection entry without problems - something you can't easily do with collection numbers. | | | Regards
Lars |
|
| mvagh | | ..thanks for all the fish |
| Registered: June 5, 2007 | | Posts: 5 |
| | Posted: | | | | Thanks for the quick response , I'll check it out tomorrow  | | | regards
Gertie |
|
| mvagh | | ..thanks for all the fish |
| Registered: June 5, 2007 | | Posts: 5 |
| | Posted: | | | | Okay, couldn't wait till tomorrow. so I checked and basically the location/slot seems to do the trick. However by printing my report (LunatiCs report 5 per page) i don't seem to be able to put the location/slot on my report.
Any ideas or am I missing something?
Thanks again..
Regards Gertie | | | regards
Gertie |
|
| Registered: March 15, 2007 | | Reputation: | | Posts: 5,459 |
| | Posted: | | | | You need to add "Disc Information" to your report and make sure that both "Show Locations" and "Show Slots" are set to true. |
|
| mvagh | | ..thanks for all the fish |
| Registered: June 5, 2007 | | Posts: 5 |
| | Posted: | | | | Hi Northbloke,
That certainly did the trick !!!
You saved me from a night at my desk poking around the report writer. I'm a happy girl now......... | | | regards
Gertie |
|