Picture managing.

July 2, 201411 yr

Newbies

I am a regular user of FileMaker.

However in my job I currently need to build a database of a few thousand invoices from different firms plus additional invoices.

My situation to insure the quality of my work I need to write in File maker what is each invoice but I also need to keep a copy of the invoice as a picture.

ATM I use drag and drop.

So far everything is good.

The problem is that I want to create some safety feature that will keep 2-3 copies at all time in case the database would become corrupt.

Still no problem EXCEPT the SIZE of 2000-3000 and growing pictures of invoices.

So here is my question. I know it is possible to script the pictures so you can save them some where with the # ex:# record-NAME-A (A-B-C-D depending on the amount of pages for the invoice), however I can't find a way to automatically linking them without them staying as part of FileMaker.

So what I would like is that if I go get my record 1, Filemake go get my picture 1-name-A and post them in my template at the A spot WITHOUT leaving it there after I left this record.

Thanks you for your assistance.

Pierre-Hugues

July 4, 201411 yr

I'm not following your explanation, but a few thousand pictures is not that large if you keep the sizes in check. Use the get thumbnail step to resize them to 2000 x 2000 then keep daily backups of your filemaker solution. Then use a 3rd party backup to keep a copy of your backup ( not your live file! ) everything will then Be redundant 2 levels deep.