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