Contact List from Multiple Entries
I'm new to FM and trying to figure out how to make a contact list from a database that contains multiple entries for the same contacts. Each entry is a record of a transaction and I want to be able to see each contact as a single record. I was hoping to be able to do this as a layout in the same database as the transactions because the file is shared over a network and I would like everyone to be able to see and edit easily. I was also hoping to use this to make sure that in the transaction list, all the contact information is the same.