Copied from the spending tab thread:
[quote name='botticus']
[quote name='erehwon']I was wanting to know if any of you guys have any experience with Access because I was thinking of making a Game spending database for my self. I was wanting to be able to input what games I had gotten for each system for each store.
Here is a link displaying the relationships. The way I have the game store table tied to the system table will produce a system entry for each store. I don't need a table with 13 system entries multiplied by 10 or more stores. I'm not really sure how to get this the way I want it.[/QUOTE]
Might as well get
SQL Server 2005 Express. I believe it's free at the moment. Much better than Access in every way. I pretend to be a DBA a quarter of my job, so PM me if you want to work something out with the schema (don't want to clutter up this thread with too many replies - or start another thread somewhere... not sure where that would go - this forum, maybe?). I've never actually thought of working it out in a database, I just use a spreadsheet.[/QUOTE]
erehwon intrigued me with this idea (no clue why I hadn't really given it thought before; I just use a fairly straightforward Excel spreadsheet right now). But I'm now in the mood to put together a little front-end interface for a database-driven spending tab tracker. Would consist of basically a simple form to input the data you would expect (game, system, price, tax, shipping, store, date, etc), drop it in the DB, then let you display a total list, system-specific list, store-specific, etc.
I'll probably mock up an ERD tomorrow based off erehwon's initial idea, unless someone feels like doing so before then. And of course, if no one else is interested in this idea, this topic can die and we can move on to other spending tab discussions.
