Copying field contents into another field
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?