2 Replies Latest reply on Nov 14, 2014 11:13 AM by melissajaffray

    Calculation for field regardless of table

    melissajaffray

      Title

      Calculation for field regardless of table

      Post

      Hi,

      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!