July 30, 200817 yr 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
July 30, 200817 yr Author I can't import a folder. It looks like I just needed to dig deeper. Edited July 30, 200817 yr by Guest posted too quick!
Create an account or sign in to comment