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

L

lacid

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!!
 
L

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
 
J

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

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]
 
Top