Get a value from a related table's, related table.
I'm new with FM so I'm having trouble figuring how to do this:
I have a table called "PaymentTerms" that has my payment term options and the number of days, for example "NET15 / 15"
I have a table called "Supplier" that is related to PaymentTerms via "__fk_PaymentTerm"
I have a table called "Purchase" that is related to Supplier via "__fk_Supplier"
In a layout based on the "Purchase" table, i would like to display the Days value from the "PaymentTerms" table and also use it on calculations based on the related "Supplier" record.
Any help MUCH appreciated.