AnsweredAssumed Answered

Find records in related table

Question asked by user2147901 on Oct 24, 2018
Latest reply on Oct 25, 2018 by philmodjunk

Hi I am new to filemaker. I would like to find the records in related tables. I have 2 tables invoice and invoice line item.

I have a layout based on invoice table. Now I would like to find records in invoice line item table. For example, the name of item(contract term 1). I would like to display the result in invoice table. Is there any ways to achieve this?

 

Invoice table and invoice line item table are under this relationship. invoice::id <--> id_invoice.

 

I am using filemaker 17.

Outcomes