Recordset Question

[Dillinger4]

Does anyone know how i could go about adding information to the same field in two sepreate tables?
I have a Account ID field in another table called Route Information. Somebody suggested using an innerjoin but isnt that used to extract information from two seperate tables
rather then input?

Set rs = db.OpenRecordset("Account Information")

rs![Account Name] = frmAccountSetup.ctrlAccountName.Text
rs![Account Address] = frmAccountSetup.ctrlAccountAddress.Text
rs![Account ID] = frmAccountSetup.ctrlAccountID.Text
rs![Phone Number] = frmAccountSetup.ctrlPhoneNumber.Text

' I tried using this, i thought i could refrence the field name with the table but it doesnt work. lol

rs![Route Information].[Account ID] = frmAccountSetup.ctrlAccountID.Text


Thanks All...... =C)

[AKA]

Shouldn't a second recordset solve the problem ?


Set rs = db.OpenRecordset("Account Information")

rs![Account Name] = frmAccountSetup.ctrlAccountName.Text
rs![Account Address] = frmAccountSetup.ctrlAccountAddress.Text
rs![Account ID] = frmAccountSetup.ctrlAccountID.Text
rs![Phone Number] = frmAccountSetup.ctrlPhoneNumber.Text

Set rsRoute = db.OpenRecordset("Route Information")
rsRoute![Account ID] = frmAccountSetup.ctrlAccountID.Text