Products belonging to more than one category....???

[Gilberto]

Hello,

I have a table ENGINEERING with the following fields:

PRODUCT NAME
LEVEL 1 DRIVER
LEVEL 1 PASSENGER
LEVEL 2 DRIVER
LEVEL 2 PASSENGER
LEVEL 3 DRIVER
LEVEL 3 PASSENGER
LEVEL

I created a form (ENGINEERING) where the user enters the name of the product and enters the number of units that product belongs to at each level.

ie (ENGINEERING TABLE)

PRODUCT NAME------LEVEL 1 DRIVER----LEVEL 1 PAS----LEVEL 2 DRIVER...

ARMREST----------------------------2--------------------------0--------------------------1
HEADREST--------------------------0--------------------------2--------------------------1
CUPHOLDER------------------------1--------------------------0--------------------------0
etc
etc

I need some code for the form, so that in the LEVEL field i can get a "1" if the product has ANY units in that level or "1,2" if the product has units in the level 1 AND level 2.

HOW CAN I DO THIS?

Thanks,
Gilberto

[Scott Price]

First of all you should take a good long look at the Database Normalisation Tutorial.

Ask any question you need until you fully understand the concepts involved. After making the changes to your table structure, we'll be glad to help you accomplish what you need to do.

Regards,
Scott