2 Replies Latest reply on May 5, 2013 10:48 AM by hrcap

    Copying field contents into another field

    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