Cascading field values
I have a table(Fabrics_Library) in DB(Translations) to which I've had to add a couple of fields and users have been updating these fields with info.
I have also added 2 fields to the table(Program_fabrics) in DB(Programs), there is a TO of Program_Fabrics in the Translations DB which is linked to the table Fabrics.
I've also added 2 fields to a table(Style_Fabrics) in DB(Style_Main), there is a TO of Program_Fabrics in the Style_Main DB.
I need to have the fields in Programs::Program_Fabrics and Style_Main::Style_Fabrics updated with the info from Translations::Fabric_Library.
Is it possible to have a calculation to cascade the info into the new fields in Program_Fabrics and Style_Fabrics and if so how does one go about this?
Hope this clear(like mud maybe).