This is the very definition as to why filemaker is a relational database.
You should have an Artists table that is related to your existing Works table by an auto-entered serial number.
Since your Artists table will list all name and other Artist specific data in a single record, changing the artist's name involves editing a single record.
Note: there are ways to set this up with your existing table and data that does not require you to manually enter massive amounts of data.
I'm pretty new to Filemaker 9 so I don't really know how what you mean by the seperate tables. Because I entered all of the information into an inventory. So does that mean that I have to create a new database with Artists in it, and another database with Works in it, and then connect them all?
If there is any way you could indicate a step-by-step process, I would really appreciate it. Thank you
Well, you don't have to do anything, I'm only recommending. Davidander's post is one way to quickly fix your immediate problem.
You can Use Manage | Database | Tables to create new tables that are part of the same file. Once you've named and created a new table you can click the fields tabs to define the fields for this new table and click the relationships tab to link it to other tables.
A useful term to look up in the Help system at this point: Portals--this is a useful tool for working with related records.
Decide whether David's suggestion is all you want to take on at this point or if you want to also follow my suggestion. If you decide on adding an artists table, follow the above steps as much as you can and report back. I or another poster can take you to the next step from there.
Thank you. I will try the replace command, but I'm thinking that for connections in the database I should probably use the relationships command. I'm out of the office until next week, but I'll report back then.