i have this structure in my app
“companys” are all customers or non-customers. The “clients” table are always clients.
In the “Companys” table you can insert a new company, let’s give an example with the name “JUBE” but that is not a client yet. Your key in the “companys” table is the company_id which can be for example “1034A”. The company “JUBE” then becomes a client and appears in the “Clients” table with an automatically generated company_ID
Now I needed to go to the “Companys” table and change the company_id to the company_id of the “Clients” table to be linked with the “Companys” table How can I do this knowing that the company_id is the key
Can you help please