Good day,
I am just looking for some guidance on the following problem. I feel if I explain it more so then attached my database, I will learn easier. Here goes:
I have three tables:
tblSourceTable(This is a Linked table from another Database)
tblEmployeeMain
tblUpdateTo
Basically I want to take fields from the tblSourceTable & tblEmployeeMain and add it to tblUpdateTo. The tblSourceTable & tblEmployeeMain have a common field - txtID. I was thinking just create a query based on the tblSourceTable & tblEmployeeMain, but I don't know how to add the fields to the tblUpdateTo.
After reading this over I decided to attached the db anyhow. It will bring it all together.
Thanks
________
chevrolet beauville
I am just looking for some guidance on the following problem. I feel if I explain it more so then attached my database, I will learn easier. Here goes:
I have three tables:
tblSourceTable(This is a Linked table from another Database)
tblEmployeeMain
tblUpdateTo
Basically I want to take fields from the tblSourceTable & tblEmployeeMain and add it to tblUpdateTo. The tblSourceTable & tblEmployeeMain have a common field - txtID. I was thinking just create a query based on the tblSourceTable & tblEmployeeMain, but I don't know how to add the fields to the tblUpdateTo.
After reading this over I decided to attached the db anyhow. It will bring it all together.
Thanks
________
chevrolet beauville
Attachments
Last edited: