5 Replies Latest reply on Nov 24, 2009 12:23 PM by DorskyGallery

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

    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.