Add category field to screen to allow multiple pick then search
I'm new to FM (1 week) and have used one of the standard 'Contact Management' templates to create a database.
I've then imported (rather difficult) a file of Mac Address Book contacts into the database and mapped the fields.
I want to create a new field on a contact record which allows me to specify one or more 'groups' that the record might belong to, e.g. promoters, press contact, tv contact
Please can anyone advise on what this type of field is called, how to set it up on the record, and if I can use an Excel file as the data source as all the values for the 'groups' field are stored in an Excel file.