Yes Hans, Raj has got it right. We have brand name. A user can enter anything in that free text field. Also if I select a particular manufacturer then I should not be able to select brand of another manufacturer. So I idea to introduce a new brand table and manufacturer-brand table get points.

Regards,
Shailen ([email protected])
+91-9216020360
Mohali, Chandigarh - 160062


On Thursday 16 December 2010 06:39 PM, Raj Saini wrote:
Hi Hans,

Brand name field is a free text and there is no relationship with manufacturer. If a product is manufacturer A it it must be associated with brand related to that manufacturer. Brand Name field does not enforce such constraints.

Thanks,

Raj

On Thursday 16 December 2010 06:32 PM, Hans Bakker wrote:
A manufacturer = supplier which produces products, on the product you
can define suppliers. A product has a brandname field.

so what is missing?

Regards,
Hans


Reply via email to