AnsweredAssumed Answered

Cascading field values

Question asked by mfl666 on Mar 12, 2012
Latest reply on Mar 13, 2012 by mfl666

Title

Cascading field values

Post

Hi,

Situation:

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.

Issue:

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).

Thanks

Michael

   

 

Outcomes