database design

[Guest]

A manufacture table stores make, model, price, colour and options information.
The available make calibras has two models 2.0i and 2.0i16v and bmw car two
models p610 and p612.

My question how to create a database that doesn't allow the user to enter
the make of the car as bmw and model as 2.0i.

 

[Guest]

You can use the validation property of the field in the table.

 

[John W. Vinson]

A manufacture table stores make, model, price, colour and options information.
The available make calibras has two models 2.0i and 2.0i16v and bmw car two
models p610 and p612.

My question how to create a database that doesn't allow the user to enter
the make of the car as bmw and model as 2.0i.

Typically one would have two tables in a one to many relationship: Makes
related one to many to Models. The Models table would have a Make field as a
foreign key, referential integrity enforced, to the Makes table. Only
authorized users would be allowed to add records to the Models table (and
you'll have to have some trusted user, maybe yourself).

John W. Vinson [MVP]