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

    Copying field contents into another field



      Copying field contents into another field


           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