I am very new to FileMaker. Can I know do FM support complicated queries? I am doing a project which need to deal with transactions (Quote, Order etc) calculation. Quote and Order have different calculation so I need to customize the query. Besides that, Quote and Order for my project are in separate Excel file and I need to do calculation in FM and combine the results into another table.
Thank you in advance for helping