AnsweredAssumed Answered

Copying field contents into another field

Question asked by hrcap on May 5, 2013
Latest reply on May 5, 2013 by hrcap

Title

Copying field contents into another field

Post

     Afternoon Everybody

      

     On my solution i have a table called COMPANY, within this table the company enters their basic information for example, the company name and the company address. I have a Primary Key field within COMPANY titled: kp_company_id which holds a unique identifying number for that company.

      

     I have a table that links a few tables together called LINES, within this table i have made a field called kf_company_id to link with the field in COMPANY titled: kp_company_id.

      

     There will only be one company entered into the COMPANY table.

      

     How would i get kf_company_id to copy the contents of kp_company_id?

      

      

     Many Thanks

Outcomes