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