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!