Pull data from one tbl and write to another

[teiben]

Not sure how to do this...any suggestions (I usually create my forms based on table), I need to have a form that pulls from an external db (I can't write to) so it looks up to (customer info)
then the user enters info on a form and all the information on the form gets written to many tables, but not the table that the info was pulled from...should I just create form based on a query and pull in all the fields?

thanks