J
John
Hello.
I have a master Company table with two columns WorkerID and WorkerName. I
also have a lookup table named Worker with the fields WorkerID and Name.
What it should do is show in the Company table the workerid and the
ASSOCIATED workername, based on the relationship it finds in the lookup
table.
(i.e. workerid 78 is workername john jones, workerid 84 is workername bill
smith, etc.)
As it is, in my Company table, it shows in the WorkerID column 78 and 84. In
the workername column, it is blank.
How do I get the master table to recognize the relationships that exist in
the lookup table??
Thanks for help!
John
I have a master Company table with two columns WorkerID and WorkerName. I
also have a lookup table named Worker with the fields WorkerID and Name.
What it should do is show in the Company table the workerid and the
ASSOCIATED workername, based on the relationship it finds in the lookup
table.
(i.e. workerid 78 is workername john jones, workerid 84 is workername bill
smith, etc.)
As it is, in my Company table, it shows in the WorkerID column 78 and 84. In
the workername column, it is blank.
How do I get the master table to recognize the relationships that exist in
the lookup table??
Thanks for help!
John