Group tables in one
Hello, I would like to be able to group several tables in a table automatically for the update. Thanks for your help
Alain
6 replies
-
@Alain,
Please provide a more detailed use case description.
-
Okay. I have several tables according to the device
I would for example put all the brands and models of médical vacuum as well as the ECG (electrocardiographs) in a single table (table brand and models). if the update can be done as and when the tables are completed .. it would be perfect.
thank youMédical vaccum table
ECG table
Final table Marque & modèle All devices
-
Hmm.. not totally following the logic.. but that is ok.. First ..pick the table(s) that will be system of record.. I am assuming it would be "Médical vaccum table" and "ECG table" ... then.. in the Trigger after update... code logic to update the "Final table Marque & modèle All devices".
That said, another approach is to make a composite table structure such that all the common attributes (make, model, image, etc) are at the "Final table.." level... and any specific attribtues are at the subtable / composite level.
Not knowing all of your use cases.. hard to say if this is a better approach.
-
hello and thank you for taking the trouble to answer me. I agree with you regarding the composite main table with all the attributes, then dispatche on the other tables. But in the continuity of my project, I need to feed the main table from the annex tables (médical vacuum cleaners, ECG, defibrillators ..). would you have a line of instructions which makes it possible to make this update?
Thank you and have a good day
alain -
hello, if you had a line of code to group several tables into one, that still interests me. thank you
-
Not sure if it is possible to copy images from one table to another with a line of code.
Anyone?
Content aside
- 4 yrs agoLast active
- 6Replies
- 957Views