Hi,
I'm trying to create a db for my 1000 cd library. I want to have admin screens for adding, deleting, and editing entries, and also screens for my buddies to search when they want to borrow one of my cds. Since some cds are soundtracks and some are not, I have duplicate songs on cds. So making just one table will be sure to duplicate info. Can someone give me an idea about the number of tables I'll need, and what fields for each table? Is there an example on the web somewhere? (I couldn't find one.)
Thanks, J