hi all,

i have two tables
table1
-ID(PK)
-price
-Description
table 2
-ID(FK)
-Parts
-Details

Each product is having a unique ID.
but every product will have different parts(say 5 parts for the product with ID=23)

how can i insert(or have) multiple values for the parts and details fields for a single product(with ID=23)

is it possible?

can anyone give me an idea, how can i design my table structure(so that i can have the above requirements

hope the problem is clear to all
thanks in advance

So what kind of application are we helping you build? (Just curious because of your frequent posts)

Table 1 is ok table 2 should be

pk (int auto incerement)
product_fk (id in your example)
Parts
Details

So a row in table one could look like this:

Table 1
ID PRICE Description
1 5.00 Widget A

Table 2
PK Product_fk Parts Desc
1 1 Cog A Some Cog
2 1 Cog B Another Cog
3 1 Cog C Yet another Cog
4 2 Cog D A cog

etc

You would then just join your tables like this ... join table2 on table1.id = table2.product_fk

hth

"The one language all programmers understand is profanity."

thanks sir