TRANSFER VALUE

  • Thread starter EMILYTAN via AccessMonster.com
  • Start date
E

EMILYTAN via AccessMonster.com

I have a table OpenJob with all the item number. This means a job can have
many item. ok..

I have another table which is the item table.
So, i want my item to be only allocate to the openjob table if only the job
number exist in the openjob table.

How? I already know how to check whether the job number exists or not... Now
problem is how to transfer the item number to the appropriate job if only it
matches the job number with the other table...

Example
Remarks : Job1 Item: 5666A
Remaks : In Item 5666A

I want the value of Item 5666A of Job 1 to be transfer to the OpenJob table...
while the Remarks In 1 will stay the same...
ANY IDEA?
 
Top