Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updata a table with another table but they are not linked

Status
Not open for further replies.

Dina01

Programmer
Mar 26, 2002
204
CA
I have 2 tables, one of them I import from another program and it gives me the status of the employees, and the other has all the data, but I can't link the tables since the table employee has no Primary key, because an employee can be in this table multiple times.

I have a form that I enter data in, and then it saves it to another table. But when it saves I have a field named Code that gets update, but I need the code field from my table Employee to get update to.

Is this possible since the 2 tables are not linked....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top