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.