Amema
New Member
The situation is this:
We are a lot of people spread across a nation. Each of us have old books, many of which are the same, but we don't really need all of them. To be able to find out which one's we may donate or throw away, we are about to set up a page where we may all add our books.
The books will be in cupboards or stored in Boxes. The cupboards and boxes will be in a Place. Some boxes may have the same id, but in different Addresses.
I have made three tables:
Books
Boxes
Places (may be several addresses in the same city)
In Places I add City, Address, Contact 1 and Contact 2
In Boxes I add BoxID, Type and Comment plus db join Places:Address
In Books I add all sorts of info plus db join Boxes:BoxID
As I forsee that some boxes and cupboards will get the same name/ID, I would like to also add the address of a box in the Book table. Is that possible, as it is a kind of a third relation? I haven't figured it out by myself yet...
We are a lot of people spread across a nation. Each of us have old books, many of which are the same, but we don't really need all of them. To be able to find out which one's we may donate or throw away, we are about to set up a page where we may all add our books.
The books will be in cupboards or stored in Boxes. The cupboards and boxes will be in a Place. Some boxes may have the same id, but in different Addresses.
I have made three tables:
Books
Boxes
Places (may be several addresses in the same city)
In Places I add City, Address, Contact 1 and Contact 2
In Boxes I add BoxID, Type and Comment plus db join Places:Address
In Books I add all sorts of info plus db join Boxes:BoxID
As I forsee that some boxes and cupboards will get the same name/ID, I would like to also add the address of a box in the Book table. Is that possible, as it is a kind of a third relation? I haven't figured it out by myself yet...