AnsweredAssumed Answered

Calculation for field regardless of table

Question asked by melissajaffray on Nov 13, 2014
Latest reply on Nov 14, 2014 by melissajaffray


Calculation for field regardless of table



I was wondering if there is a way to do this. I have a field that has the same name in a few of my tables and I want to make a script that will use that field regardless of what table it is in. For example, say I have the field d_product in tables GROCERIES, COOKING, FARMING and EATING. Is it possible for me to make a calculation that will let me use the field d_product without having to manually specify the table? 

I have already tried Get(LayoutTableName) & "::d_product" but it does not seem to work. Thanks!