grabbing data from related tables in forms

[John]

I have a form which displays data from "tblClients" and
updates entered data in "tblLog". The displayed (and not
entered)info uses DLookup in a text box display. I have
other Data that the form needs to pull from "tblClients",
does not have to be displayed (ok however if it is) but
needs to be entered into "tblLog' when the form is saved.

Any guidance as to have this happen would be appreciated.

Thanks,

John

 

[John Vinson]

I have a form which displays data from "tblClients" and
updates entered data in "tblLog". The displayed (and not
entered)info uses DLookup in a text box display. I have
other Data that the form needs to pull from "tblClients",
does not have to be displayed (ok however if it is) but
needs to be entered into "tblLog' when the form is saved.

Why?

Storing data redundantly is almost never justified. If you have
information (other than the ClientID) that you want to copy from
tblClients into tblLog, you should have a very good reason for doing
so. What information do you want to store, and why?