Import image to container based on condition

[JimmyLewis]

Hi,

I am somewhat new to filemaker and have started to create a financial db of all my transactions for my personal use.

Other than the table i created called "Transactions" i have a related table called "receipts". When in a transaction, i click on a button to create a related record in receipts. My problem is the container field. Instead of for each transaction the requires a receipt (not all transactions have receipts) I am inserting the proper receipt. This is tedious and lengthy.

What i wish to do is to create a script that will import all my receipts. I would like to name each receipt (manually is my only choice) with the name of the "serial_id" of the transaction. Then, the scripts will see if the name of the file matches the name of the field "serial" and based on that import as necessary.

Is there a way to do this or alternatively, a more efficient way?

Also, considering i wish to store the file on filemaker and NOT create a path, what is the best format for the receipts to be in in order to save space? jpeg or PDF?

Any help would be appreciated.

Thanks,

Jimmy