AnsweredAssumed Answered

How do I enter data in a field and have it apply to more than one record?

Question asked by DorskyGallery on Nov 24, 2009
Latest reply on Nov 24, 2009 by DorskyGallery

Title

How do I enter data in a field and have it apply to more than one record?

Post

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.

Outcomes