I am setting up a database for casting. Obviously I need a separate record for each actor who auditions and I have set up a workflow to import a photo from a digital camera -- that was easy.

However, I need to take four photos of each actor: slate (identify) and the front, side back.

When I import multiple photos it just creates multiple records. I need all photos to appear in the same record. I've heard of something like creating a table to hold the additional photos but I don't know how to do that.

The goal is to have one and only one record for each actor that has their contact data, notes and the four photos.

How can I set that up so that it involves a minimal number of steps. The casting assistants who will operate this are not savvy -- I need it to be as much of a "push-button" operation as possible.

Alternatively, maybe an Automator or Applescript solution is a better way to go?

Edited October 31, 200916 yr by Guest

I would create a separate table for photos, "Images." Relate this table to the Actors table by ActorID.

Have a portal to the images table on the Actor form view. You can show 4 tall rows or use the portal tools ability to show 1 row starting at row 2 to have 4 portals each starting at a different row.

I also wouldn't store the photos in the Images table, but rather their referenced path.

Sorry, but I really don't know Filemaker all that well. I'm not sure how to "create a portal" or even how to make a separate table. I know how to create a database. Is a "table" just a database that is related to the main database?

How do I get the photos to import to that table?

I very much want to avoid having to import them individually. My goal is to take the four photos and them import them and have each one go to it's own container.

Edited November 1, 200916 yr by Guest

FileMaker ships PDF documentation in the "Electronic documentation" folder. Start with the tutorial that is a step by step guide to FMs features.

There are also some pre-built files that demonstrate many of its features - have you had a look through those yet.

Sorry, but unless you choose to hire a FM developer, you will need to crack open a manual. You won't understand our answers until you have some idea of the terminology.