How do I get data from one form to two tables?

[Guest]

I am entering transactions into a transaction form which then sends info. to
the transaction table. I need info. on the transaction form to also be sent
automatically to a client info. table. Each client has a unique ID# and I
have fields set up for the info. in a client form and client table. Can
anyone help! I've been racking my brain!!

 

[Joseph Meehan]

I am entering transactions into a transaction form which then sends
info. to the transaction table. I need info. on the transaction form
to also be sent automatically to a client info. table. Each client
has a unique ID# and I have fields set up for the info. in a client
form and client table. Can anyone help! I've been racking my brain!!

While avoiding the question why you would be saving the same information
in two tables (it sounds wrong) You could use an update event based on a
trigger on the form. Exactly what event would depend of the specifics. I
suppose you could also trigger an update query as well.

 

[Larry Daugherty]

First be sure you're solving the right problem. One of the relational
rules is that you don't store data redundantly in the database If the
data you need is already in the Transaction table then it needn't be
in the Client table. Any time the data is needed for display or
reports, find it in the Transaction table.

HTH

 

[John Vinson]

I am entering transactions into a transaction form which then sends info. to
the transaction table. I need info. on the transaction form to also be sent
automatically to a client info. table. Each client has a unique ID# and I
have fields set up for the info. in a client form and client table. Can
anyone help! I've been racking my brain!!

Joseph and Larry are (as always) right on with their advice: Unask the
question. Storing data redundantly is *NEVER* a good idea.

If - for some reason that I'm not seeing - this is not in fact
redundant data, you will need VBA code in the Form's AfterUpdate event
to open a recordset on the client table and make the appropriate
updates. Post back with an explanation of why you're doing this, and
what you need to update, if you decide that you really have a good
reason!

John W. Vinson[MVP]