Posted by google on 09/21/05 23:13

Thanks for the reply.

>> I am using MySQL to keep a database containing tables 'merchants' and
>> 'products'.
> >My 'products' table has an auto-incrementing id for each record, other
> >fields, and a 'merchant' field.

>In other words, you decided not to use merchant's product numbering
>system? Is this wise?

do I not run the risk of having duplicate numbers as product_id ? It is
a primary key.

Is there a way of using the value of one field in a table to generate
the contents of another field in a seperate table ? Like in Excel ? Or
would this have to be scripted ?

[Back to original message]