hmm I see, so it is a questio of modeling after all, ok thanks for your answer, apreciated ^^
by the way, if I want to use one weak entity say companies & products
and the product goes something like
create table product(
`id` int(11) UNSIGNED NOT NULL,
`company_id int (11) UNSIGNED NOT NULL,
PRIMARY KEY( `id`, `company_id`)
whats the correct way of doing this, with auto_increment on the id ?
I was wondering if it is possible to have something like:
company 1 product 1 /
company 2 product 1
company 1 product 2
(only incrementing within the same company automatically)
is it possible or is not a good practice?