1 Reply Latest reply on Dec 5, 2016 2:10 PM by philmodjunk

    How to have multiple invoice numbers listed on same record when showing search results?


      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:


      FirstName     "John"

      LastName     "Doe"

      Phone          "325-654-8753"

      Address       "123 Main Street"

      Cases          "CS1001" "CS1056" "CS1059"


      Thank you very much for your assistance