Hi
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
Solved! Go to Solution.
You may want to use a bot to add a new row in the “Companys” table, everytime you add a row to the Clients, or People, or Visit.
And this table will need to have minimal columns:
UNIQUEID()
You will need to use some tricks
Here are some documentation that may help you into achieving your goal, depending on it.
A row’s key column value cannot change once the row is saved the first time.
In this situation how to solve this problem to create the app
How can we resolve this problem ? Anybody know?
You may want to use a bot to add a new row in the “Companys” table, everytime you add a row to the Clients, or People, or Visit.
And this table will need to have minimal columns:
UNIQUEID()
You will need to use some tricks
Here are some documentation that may help you into achieving your goal, depending on it.
Thanks a lot for the tricks
You are welcome
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |