AnsweredAssumed Answered

Getting related field name?

Question asked by yuichim on May 26, 2011
Latest reply on May 27, 2011 by yuichim


Getting related field name?



I am working on a sales order solution that has following tables.

1. Order table, Order Items table, Products table.

In Order Items table, kf_productID is related to kp_productID in Products table.  There also is a productName field in Products table.

What I am trying to do is : I created a field called ProductName in OrderItems table which is a calculation field to get the product name by looking up the kf_productID in Order Items table.

I am having a hard time to figure out the calculation...  Is this the best solution for what I want to do?

Any help much appreciated!