Updating a field in a table

[Leventcos21]

Hi, I have two tables that are intersection entities. Both tables have a field called EmpNo. Table 1 has contains EmpNO. How can I get it so that Table 2 also to hold matching EmpNO.

A query Update will not work because, the joining filed is not unique. However, If I can get EmpNo field updated in table 2, this will allow me to have unique fields.

Thank you,

 

[MallardVHS]

Hi Lev,

I did not completely understand your question.

It sort of sounds like a form/subform issue.

If so, look into using multiple fields (joined) as your primary key.

Best luck,
Don

[blue]________________________________________________________
Some folks put their money where their mouth is. I just pay my bill. [/blue]