I am working in a membership tracking filemaker app that is connected to MySQL through ODBC.
I have one table of payments in MySql and another table of other payments in a Filemaker table. Essentially online and offline payment tracking.
Is there a way to get these two tables to show up in one portal (on the member's contact information layout) such that I can see every time they have made a payment regardless of online/offline affiliation and moreover, summarize the total amount paid for records in that portal?
Thank you for any and all adivice!
I'd look for a way to combine those tables and have them as one, and just indicate within each transaction if it were online or of offline. I'm going to guess that isn't an option, and that you want these presented in chronological order.
One option would be to create an intermediate table - linked to both of the transaction tables, and sorted by the transaction timestamp.