Hi all. I am trying to build a small simple database for a lending library.
Basically, I have a table of resources to be lended out, and a table that will store a
user's name and what they have borrowed.
My problem is that we may have more than one copy of a given resource say a book.
So I thought I would just create each row in the resource table as an auto_increment
integer and assign that the primary key...
How can I make that auto_incrementing field the foreign key and a compiste primary key
in the user table?
Thanks,
Taylor
****************************************************************
Please Note
The information in this E-mail message is legally privileged
and confidential information intended only for the use of the
individual(s) named above. If you, the reader of this message,
are not the intended recipient, you are hereby notified that
you should not further disseminate, distribute, or forward this
E-mail message. If you have received this E-mail in error,
please notify the sender. Thank you
*****************************************************************
