This is an example app to answer the query in this community question:
https://quickbase-community.intuit.com/questions/889863-creating-a-formual-field-using-a-formula-from-another-table?jump_to=comment_2038525
Objective:
- incorporate a lookup field from a parent table to calculate a value using formula fields
Solution:
- 2 table: Companies, Debts
- LPInterest RateTotal is a Formula-Numeric field on the Company table
- the Debt table looks up that value in [Company - LPInterest RateTotal]
- the Interest fields uses that lookup field as part of the formula calculations