Split one row records to several rows

[harpreett.singhh@gmail.co]

Hello,

I have strange requirement out of my newly setup database.

I have a table where one audit is recorded as one record. there are number of actions for that audit.

I want to list all the actions under one audit in different rows. At the moment all records are listed horizontally into one record / row but it needs to be listed so that later I will be making a union query to link several records to multi rows vertically.

So this will become a register to see all the actions from which audit and we can sort out actions individually rather than horizontally looking on the right hand side.

Please advise.

[June7]

Use a UNION query to rearrange the data. If you want to normalize data structure and create new records into this new structure, make a new table with the UNION results.