Is there an easy way to pull the data from a specific field in a related table? So far, it doesn’t seem so.
Let’s say I want to use a dollar value from an assets table and use it in a another table to add the amount to another asset? Or say to look up an amount balance in an accounts table so when I purchase an item I can subtract that amount in a purchases table? Ideally the amounts would be calculated/updated in their original tables.
It seems I can only access the name of the table in the related record. Thanks for any thoughts.