Given two tables: [Invoice] [InvoiceItems]
I went much simpler… The many to one from InvoiceItems to Invoice I simply name invoice The one to many from Invoice to Invoice Items I simply named invoiceItems Then the dot notation comes out to be Invoice.invoiceItems InvoiceItems.invoice Neil ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************