I would guess that you already have your relationships set up. If you have a contacts table then you probably have a relationship between your invoice table and your contacts table like so:
And I assume you also have:
If this is the case you could just put a portal on your layout based on the contacts table.
The portal should be based on the invoices table and show:
- The InvoiceId from the invoice table. (or an invoice number or date)
- The Description or name of he workshop
- and any other fields you want to see.
If you need any further help or an example file, let me know.
Thanks so much for your help. That is what I tried and it didn't work. Setting the portal relationship to a different table and back again. Then creating different records made it snap in.
Thanks again for your help. You rock!