Show multiple information from related files
Trying to go futher in my usage of Filemaker Pro 12
I have a database with multiple files
Files for Invoice, product, product_categories and product_subCategories
In the product layout I would like to link using an IdKey and show description for Categories and subCategories, so far it work for Categories but not for SubCategories. Choice is made using list that show the good value but layout is not updated.
In the invoice layout I have lines for Invoice_Detail that need to show product but also product_categories and product_subCategories
I have try many combination but all fail.
Thanks for suggestion or example available