Edit Key tables

Tiago_Pereira
Participant III

Hi

i have this structure in my app
3X_3_6_366f9c02a97eb0f42c1370b8c735c72e5bac3feb.png

“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 Solved
0 6 167
1 ACCEPTED SOLUTION

Hi @Tiago_Pereira

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.

View solution in original post

6 REPLIES 6

Steve
Participant V

A row’s key column value cannot change once the row is saved the first time.

Tiago_Pereira
Participant III

In this situation how to solve this problem to create the app

How can we resolve this problem ? Anybody know?

Hi @Tiago_Pereira

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.

Thanks a lot for the tricks

You are welcome

Top Labels in this Space