It all starts with the need for a calculated field on a report. I need to multply a price from an inventory form by qty from an activity form. I have related the forms by lookup in the activity form.
My thought is to create a calculated field in the activity form but I don't have access to the price field from the inventory form despite the lookup and relationship.
What is the best solution?
Thanks