image handling

[David Jondreau]

I've converting several flat files into an inventory database that contains about 7,000 items. Each item will have between 0 and 5 photos associated with it. Currently I have a folder with about 1,500 photos.

I'm considering two options for managing this:

1)Keep the jpgs in their folder and reference them in a separate table with a multi join to the items table.

2) Store the jpgs in a separate file and relate the main file and the photo file to each other.

I'm leaning towards #2 because that prevents someone from accidentally deleting the referenced photos.

Any opinions on that?

Secondly, I don't know how to get the images (or their references) into FM en masse. I can't import a folder. And 1,500 images by hand will be miserable.

Any ideas?

Thanks,

DJ

[David Jondreau]

I can't import a folder.

It looks like I just needed to dig deeper.

Edited July 30, 2008 by Guest
posted too quick!