I am a recent Mac convert. My primary position at work is buiding, maintaining, and using a MS SQL database with an Access front-end. I don't want to have to use a Windows box anymore so I am trying to switch over to Filemaker.
I can't seem to find anything about UNION queries in Filemaker on the web anywhere. Does anyone know if this can be done?
The reason for the UNION is to join two unrelated tables so that I can run calculations and summary reports. One table is "Employee Hours" and the other is "Expenses". We are a consulting firm that bills hours and expenses to our employees.
If you need more info I can post examples reports I can currently run in Access.
Thanks for any help.