creating a portal to relate multiple invoices to a single customer
I have a filemaker database that lists all of my invoices for the last 3 years. Includes fields which tell me customer name, which employee did the work, when and how much.
I also have a customer list with address and phone numbers.
Can I merge them to see the last 10 invoices that were billed to a customer on a single record?
If the answer is yes, how?