One record to another table 3 records

[Cass]

Hi!

Is it possible this idea:
table row : id A B C D E F

now i want make 3 different record to table2
rec1. A + D + C
rec2. A + E + C
rec3. A + F + C

:bug:
-----edit-----
I stopped to add new record table when rec1 is created
every time looping field D,E,F and then take new ID in table1

[geekgirlau]

I'm not exactly clear what you're trying to achieve here - any way you can post a small sample db, or alternatively a spreadsheet showing your starting point and the new records you want to end up with?

[Cass]

My english is not very good but i try explain more.

this sample is 2 table. tblMadrats is data and tblRESULT outcome.

'tblRESULT column idRiba be composed
"BO" & tblMadrats!id & "L" 'last letter depends tblMadrats check boxes value. if check box false then no result and not make new record


tblMadrats is master article and where check box is marked there are different subarticle.
earlier i make this new subarticle manually.