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
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
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