May 31, 201015 yr 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
Create an account or sign in to comment