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?