Creating Multiple Records

[Stu Dongel]

hello all,
i am setting up something to add multiple rcords to a table in the following
manor. I have a table *tblTransaction wich is related to another Table
*tblBrotherInfo. They are in a relationship via the fields
*tblBrotherInfo.ID and *tbltransaction.BrotherID. Basicly the trasaction
table is a list of credits and debits. I am trying to develop a way to do a
global debit/credit, create the same record for eachbrother in the
*tblBrotherInfo.

I tried doing this via a set of updae querys, but I am getting no where.
Any nudges would be appriciated.

Thanks so much in advance.
Stu Dongel

 

[John Vinson]

hello all,
i am setting up something to add multiple rcords to a table in the following
manor. I have a table *tblTransaction wich is related to another Table
*tblBrotherInfo. They are in a relationship via the fields
*tblBrotherInfo.ID and *tbltransaction.BrotherID. Basicly the trasaction
table is a list of credits and debits. I am trying to develop a way to do a
global debit/credit, create the same record for eachbrother in the
*tblBrotherInfo.

I tried doing this via a set of updae querys, but I am getting no where.
Any nudges would be appriciated.

Update queries update records which already exist. To create new
records, you want an Append query instead. Try basing an Append query
on tblBrotherInfo and appending into tblTransaction, with calculated
fields for the debit or credit.

John W. Vinson[MVP]
(no longer chatting for now)