Forum Discussion
Rock n roll Memorabilia inventory/database/spreadsheet/catalogue/organization HELP!
Your posting has had, as of this writing, 50 views but no replies. There's a reason for that, of course. The topic sentence invites a view, is attractive, intriguing. But then the reader gets to that run-on and convoluted description and despairs. The tag at the end regarding the Mac is the proverbial straw (the one that breaks....you know the rest).
Anyway, Database normalization is what you need. https://www.guru99.com/database-normalization.html
Database normalization is not easily achieved. It requires slowing down and getting a grip on different categories of information in all of this, making decisions on which ones are core, how different categories can be linked to others.
- Should t-shirts be contained in the same table as, say, instruments, or maybe posters?
- And if you have t-shirts from Aerosmith and from Michael Jackson, but posters only from the latter, how do you connect all those artists with their stuff?
- How about differentiating between items you want to sell and those you want to keep?
- Etc.
But it does take sitting down and starting to differentiate like that. Even creating distinct lists instead of run-on sentences.
You're not likely to find an Excel template that fits your need. In fact, you might do well to look into Microsoft Access, which is a relational database manager. But you'd do well to find somebody to help, somebody who is comfortable with analytical thinking and who likes rock and roll memorabilia. What you've written, and how you've written it, suggests pretty strongly that your talents lie in different directions.
