Data Entry for more than one item

[hurtsville]

Hi, completely new here.

I have a image database and add keywords for the images.

However, often I would like to select several images as they are similar, and type in keywords relevant to all of them.

How could i do that?

Thanks, Dimitri

[bcooney]

Welcome to FMForums Dimitri!

Adding keywords to images depends on where you're storing the keywords.

1. Are they in a big text field in the same record as the image?

or

2. Are they in a separate table, and you have a record for each keyword?

If #1, then find the records and use the Replace command to update the text field. The calculated replace will let you append keywords to the existing keywords in the text field.

If #2, then you should have a join table btw Keywords and Images, and create records in the join table. The join table simply has the Image record ID and the Keyword record ID.