mysql how to best set up tables where relation is one to several -

i trying set tables, seemed simpler me, not managing find proper way.

this calculate after sales costs vehicles each vehicle receive 1 of each of sub-group of services price list make total after sales cost.

please see scenario below:

table aftersalespricelist like:

as_id   as_description      as_value  1       service kit1          1000 2       service kit2          1500 3       service kit3          2000 ....... 10      repair kit1           5000 11      repair kit2           8000 12      repair kit3           9000 ..... 21      pneu 1                1500 22      pneu 2                2500 23      pneu 3                4000 ..... 31      battery 1              500 32      battery 2              800 33      battery 3              1000 

now, in table? place of these services each vehicle receive.each vehicle has have 1 , 1 of each item service, repair, pneu, battery,etc, in table vehicleas:

vehicle_id 1    service kit1, repair kit 2, pneu 3, battery 1 vehicle_id 2    service kit2, repair kit 2, pneu 1, battery 2 etc..... 

of course, not work in mysql, @ least far know.

is there way in mysql without need break apart table after sales in multiple tables, 1 each subset (one service, repair, battery, etc).

it work exploding aftersalespricelist table, trying make seems me more logical, ie, have after sales prices in single table.

thanks

it's 1 many relationship. both tables have primary keys. child/many table have foreign key column value point primary key in parent/one table.

you'll find children belong parent doing join on parent primary key , child foreign key.