Container Problem with External Drives

[jimkent]

I'm having some issues with understanding container fields with file references and how they are updated (if they can be updated).

I have a HUGE database of pictures. Each picture is roughly 100k and I have almost 10,000 of them. If I import these pictures into a container file. My guess is I'll have a DB roughly 2gb in size. Don't think navigation is going to be very responsive do you?

I would like to import them as references where the database will be small and the files will be stored outside of FM.

Problem: If I copy these files and the DB from one USB drive to another or If I attempt to use this DB on a Windows FM machine I loose the reference (image cannot be found error). Is there anyway to update the reference or something so I don't have to re-import all 10,000 files?

Additionally I have the pictures arranged in folders that I labeled BOOK1 BOOK2 BOOK3 etc. I have 54 book folders and 200 on average pictures in each folder. My database is at the top level folder and all these book folders are underneath. I can't imagine putting 10,000 files in one folder. That would push the file system a bit I would think.

I'm guessing I have to do some sort of scripting or calculation to the container field to keep it up to date?

Edited October 5, 2009 by Guest