Hello
The construct of our inherited database is not properly normalised and in the interim we have to work with what he have. We have a parent client record with many accounts, each account can have 'increments' to it but unfortunately this is where the construct falls down as instead of having an account parent to many increment children, a new account is created as a further child to the parent client, example Client A, has account 1, which is incremented we then have account 1 a, another increment would be account 1 b and so forth.
Due to this we have update problems as an update to certain fields in in account 1 should also be to 1a 1b etc. Here is my issue; without code can we make say field X when updated in account 1 also update in account 1a and account 1b. I can't leverage the client by the way as other accounts may rightly not have the same st ups (i.e an account2 or account3).
Hope this makes sens?
Thanks Darren