LinkedIn
Twitter
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
1 ACCEPTED 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:
- key_column, type Text, with initial value:
UNIQUEID() - client: type Ref, source table: Client
- people: type Ref, source table: People
- visit: type Ref, source table: Visit
You will need to use some tricks 
Here are some documentation that may help you into achieving your goal, depending on it.
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:
- key_column, type Text, with initial value:
UNIQUEID() - client: type Ref, source table: Client
- people: type Ref, source table: People
- visit: type Ref, source table: Visit
You will need to use some tricks
Here are some documentation that may help you into achieving your goal, depending on it.
