Creating Multiple Records

  • Thread starter Thread starter Stu Dongel
  • Start date Start date
S

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
 
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.
Click to expand...

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)
 
Back
Top