Linked Tables

[kmc]

I have form that does a name lookup from a linked table.
Once I lookup a name I would like to then click a submit
button which would input that data into a separate access
table. Can anyone lead me in the right direction on how
to go about doing that? Thanks.

 

[John Vinson]

I have form that does a name lookup from a linked table.
Once I lookup a name I would like to then click a submit
button which would input that data into a separate access
table. Can anyone lead me in the right direction on how
to go about doing that? Thanks.

Well, generally one would NOT want to do this: storing data
redundantly when it can be simply joined using a query is a violation
of the entire spirit of relational databases!

What are you trying to *accomplish* by doing this? Are you certain
that you cannot simply use a Query joining the linked table, as the
recordsource for a form or report; or use a tool such as a Combo Box
to display the looked-up value to the user?