AnsweredAssumed Answered

Selecting records that have a distinct field

Question asked by PeterArnold on Jun 23, 2015
Latest reply on Jun 28, 2015 by philmodjunk


Selecting records that have a distinct field


I am considering moving my databases into FileMaker, and I have searched the forum but I can't see an answer.... here is my problem:

I have a file of orders, with each order having one or more items. The source of this which I import into FM presents the list as one record per order item, so one order number may appear on several records. I want to print out labels to send out these orders, so I need just one label per order. So I need to ask the list to present itself as a list of distinct order numbers.  My present database can do this by clicking one button, but I can't find a similar facility in FM.

Can someone advise me please?