Page 1 of 1

Irradiating fields?

Posted: Mon Sep 04, 2017 11:18 pm
by cnporrasshared

let's say I have a companyID field in a multi-tenant application and which want to irradiate : let's say if not all but to many tables
could it be possible then copying it to all entities which has the companyID field somehow?
see ... the problem is that if you do the customization once it might be enough to have such customization available elsewhere, isn't it?

sorry if in any case you consider this question as a silly request


Re: Irradiating fields?

Posted: Mon Sep 04, 2017 11:33 pm
by cnporrasshared

I know you have options available for making copies of table and columns definitions to other entities BUT it goes only in a one-by-one basis
it could be good if at least such option could as well be available by means of checkboxes as to make multiple copies at once, isn't it?


Re: Irradiating fields?

Posted: Thu Sep 07, 2017 11:14 am
by Webmaster

If you want changes in a field in a certain table to be updated to fields in other tables, you can:

  1. Set up master/detail relationship between the tables (assuming the source table as the master table and the source field is the foreign key) and enable the [Cascade Update] option. Once the field in the master table is updated, the other related fields will also be updated
  2. If (1) is not the scenario, you can perform the update action in the Row_Updated server events yourself.