|
|
Posted by Hendri Kurniawan on 07/24/07 07:42
Dave wrote:
> I am in the process of testing a database design, which i believe I
> have hit a stumpbling block and cannot think of a way around it.
>
----- SNIP ---
> I would be grateful if someone could point me in the right direction
> to overcome this issue.
>
> thanks in advance
>
> Dave
>
Creating new tables for each company will just create more headache for you.
Why you ask: The number of tables will increase to follow the number of
company.
Solution... Just add another column on the product table (I don't know
which one it is)
to associate it with the company....
ie.
product_table(
product_id,
product_name,
company_id
)
or if you want to associate a product with one or more company
product_table (
product_id, .... etc etc
)
product_company_table(
product_id,
company_id
)
Hope this helps
Hendri Kurniawan
Navigation:
[Reply to this message]
|