grabbing data from related tables in forms

  • Thread starter Thread starter John
  • Start date Start date
J

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

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