I am new to FileMaker.
I have three seperate databases:
- Customers (Customer number, Name, Address, Account Balance)
- Transactions (Date, Transaction Type, Amount)
- Notes (Date, Comment)
I need to be able to access this data to produce a fairly complex report.
I'd like to export the data to dbase or excel files but can't work out how to write the scripts to do this. It needs to be fully automated.
My preference would be DBase but there is one field which is too long to export to DBase and I'm not sure how to handle this.
Can anyone point me in the direction of a good tutorial to step me through how to write the scripts to achieve this?