I used the term "invoice" in the query above because it is the most widely used application of what I want. In my specific situation, I am coming into a database that has been used for over 10 years, but that needs a lot of improvements to make it more efficient. What I would like to do, is have a new layout for "patient contact info" (name, phone, address, email), but I would also like it to list all surgical case numbers that already exist in the database. The case numbers are not a serial calculation by FileMaker, as they are created and assigned by the hospital using a different application, but they are unique.
Imaging it like a customer database for a store. If this were a store, I would want this layout to show the customer info AND every invoice number listed. I don't the invoice itself, just all invoice numbers.
See below for an example of my goal:
Address "123 Main Street"
Cases "CS1001" "CS1056" "CS1059"
Thank you very much for your assistance