AnsweredAssumed Answered

Special Query  PART 2

Question asked by ahutler on Mar 25, 2013
Latest reply on Mar 26, 2013 by philmodjunk


Special Query  PART 2



     I need help with response to an earlier question/answer.

     See below, where/how do i place the sequel statement? Layout mode? attached a field in a calculation type text???? I don't know how to do the provided solution.


     "Special Query


     I would like to make a list of all of the artists' names in our collection (in our filemaker db), however if we have multiple pieces by a specific artist, I DO NOT want their name repeated 10 times on that list.


     Is there a command or script or a something that will allow me to do this?

Reply to this Post

     In what format do you need that list?

     A value list based on this name field will list all names a single time. And ValueListItems can be used to pull that list into a single text field if that is of value.

     A summary report can be created with one sub summary part and the body layout part removed. Put the name field in the sub summary part and sort by name (or corresponding ID). Just be sure to sort by the field specified as the "when sorted by" field in the sub summary part's set up. (This layout will appear blank in browse mode until you correctly sort the records.)

ExecuteSQL can be used to also list the names in a single field if you use the DISTINCT keyword.

     Or you can create a table with one record for each artist. You can set a "unique values, validate always" validation on the name field and import all the records from your existing table into this new table and the validation rule will filter out the duplicates."