AnsweredAssumed Answered

Calculation field display data from related field

Question asked by raykennedy on Dec 17, 2010
Latest reply on Dec 17, 2010 by philmodjunk


Calculation field display data from related field


I am attempting to put a calculation in my table that displays data from related table. Here is the setup...

Table 1 = Transaction

Table 2 = Customer

Transaction table has two foreign id fields pulling the customer into Transaction...

Transaction::_k_seller1_id = Customer::_p_customer_id

Transaction::_k_seller2_id = Customer::_p_customer_id

So as you can see Transaction pulls two Customer into one transaction using the ID and this is displayed in the app using a popup menu or portal.

What I would like to do if possible is to put a calculation in Transaction that would pull each customers first name and last name based off the id fields and concatenate them together in one field for custom display in certain areas of my app. The reason I want it to be a calculation is so if one of the sellers information changes it will not be redundant data that needs to be changes. For example, someone misspells the last name.

Is this possible? If so, any suggestions on how to proceed?