How do I enter data in a field and have it apply to more than one record?
I am working on creating a new inventory for a gallery's art collection. I imported information from an Excel Spreadsheet. In the Excel file, the "Artist Name" column includes both first and last name. However, in the Filemaker inventory, there are seperate fields: "First Name" and "Last Name". When I imported the data, the full artist name imported into the "First Name" field only. Now I want to seperate first and last, without doing it for every single work by every single artist.
For example, there are 400 works by Richard Hunt. I want to be able to insert "Hunt" into the last name field, and be able to apply these changes to more than one record. How do I this? Please help me! Thank you.