How to create multiple records from one record?

[mkotowski]

Hello all,

I am looking for a fairly simple way to take a record with multiple columns of similar data and break it into seperate records for each column. In essence, I am trying to put the data into a more normalized form. The table consists of a column for "item #" and then up to 10 columns for "sizes". I would like to have a record for each size instead of having them spread among the one record. This way I would end up with a table that has columns for "Item", "Size", and "Qty".

Any Thoughts?

 

[PHV]

Take a look at UNION query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244