How Do This RelationShip?

[mnavahan]

Hi All

I need have one manufacture Table

With this field

1. Code

2. Price

3. Type

3. TypeDivision



Type data is (lookup for type)



ID class

ClassB
ClassA
ClassC


And have in TypeDivision must with below data table





ID ClassA ClassB ClassC

1. red largeSize 10kg

2. blue MediumSize 25kg

3. green Smallsize 30kg





this mean in type user can select ClassB or ClassA or ClassC



if type selected ClassA TypeDivision then must select red or blue or green. If type selected ClassB TypeDivision must then select large Size MediumSize Smallsize. If type selected Classic TypeDivision must then select 10kg or 25kgr or 30kgr





For ex. If (type = 2) and (TypeDivision = 3) in above data mean manufacture is Class and small size ….



how normalize above example and define table …
How show selected type TypeDivision ……




THX of your Idea ….

 

[r937]

create table manufacture
( Code
, Price
, Type
, TypeDivision
)
create table Types
( Type
)
create table TypeDivision
( Type
, TypeDivision
)

sample rows for TypeDivision --

ClassA red
ClassA blue
ClassA green
ClassB largeSize
ClassB MediumSize
ClassB Smallsize
ClassC 10kg
ClassC 25kg
ClassC 30kg

rudy

http://r937.com/

SQL Consulting

 

[mnavahan]

NIce more help how use it ...
have any other idea ?