C
Christo Yssel
Hi,
I am not sure how to solve the following problem:
I have 3 tables, Suppliers, Adresses and Clients
The address table must store addreses from suppliers and clients. A Supplier
can have more than one address, postal and lets say delivery (same for
clients). There is a one-to-may relationship between supplier and address.
Normally you would just have the SupplierID as a foreign key in the address
table and set up a one-to-many relationship between supplier and address.
The same for clients. It would work fine if I created two address tables,
one for suppliers and one for clients, but I would like to use only one
address table and link both (clients and suppliers) to this one table. I am
having problems setting up the relationship with all 3 tables.
Thanks
Christo
I am not sure how to solve the following problem:
I have 3 tables, Suppliers, Adresses and Clients
The address table must store addreses from suppliers and clients. A Supplier
can have more than one address, postal and lets say delivery (same for
clients). There is a one-to-may relationship between supplier and address.
Normally you would just have the SupplierID as a foreign key in the address
table and set up a one-to-many relationship between supplier and address.
The same for clients. It would work fine if I created two address tables,
one for suppliers and one for clients, but I would like to use only one
address table and link both (clients and suppliers) to this one table. I am
having problems setting up the relationship with all 3 tables.
Thanks
Christo