Solved adding records in two tables simultenously

[sbaud2003]

I have a form in which five text boxes (unbound) are there. Records are added through a Sub form in data sheet view. Is it possible to add records in two different tables simultaneously. First table should fetch all the data and the second one only two fields.

 

[Minty]

I'm going to ask why, as this sounds like duplicated data, and normally means a poor design or un-normalised data?
And normally a subform wouldn't be unbound?

 

[HalloweenWeed]

Suggest a table for "all fields," and a query to represent the second one.