AnsweredAssumed Answered

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

Question asked by colin_mayo on Dec 5, 2016
Latest reply on Dec 5, 2016 by philmodjunk

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