Question form mutliply the results

[butter30]

hi i was wondering if its possible to do this and if so how

tables and their fields

(alpha)
-1 pk
-2
-3

(beta)
-4 pk
-5
-6

(gamma)
-1
-4 pk

the form is created in beta containing following fields
-1 (charlie) -how do i make the data go to this table instead of subform?
-4 (beta)
-5 (beta)
-6 (beta)

i would like 4 (beta) to go to both table (alpha) and (charlie)

thank you

sidenote i have a similar post if thats against the rules can you delete the other post plz