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

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

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 sta