Designing a database to track files

2001-11-30 Thread Erik Price
Hello, I'm designing a database, and of course I have no formal training in this area (I'm learning from DuBois's book). It's designed to keep track of files. In my organization, we have a small design studio, and the designers save their image files to CD-ROMs. As you can imagine, the

Re: Designing a database to track files

2001-11-30 Thread Jens Vonderheide
Hi Erik, In the files table, each row corresponds to a separate file. There's all sorts of additional criteria, but the only one that matters to my question is the column called div_id. That's right, the number in That's exactly what I would recommend you to do. As you wrote, you can

Re: Designing a database to track files

2001-11-30 Thread Erik Price
Jens, That is great news! You've made my day -- that means that the rest of my tables should work with JOIN queries, as I am building them along the same model -- using ID numbers instead of actual names to connect to the main files table. Thanks for clearing that up for me. And also for