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!