AnsweredAssumed Answered

Get a value from a related table's, related table.

Question asked by GustavoPenaVerplancken on Nov 12, 2013
Latest reply on Nov 13, 2013 by GustavoPenaVerplancken

Title

Get a value from a related table's, related table.

Post

     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.

Outcomes