I have been tasked to create a solution for our credit card transaction (payables). I can pull the transactions from a list in our accounting system. And I can import them to FileMaker Pro. Monthly when we receive the credit card statement, I need to create a screen that is a transaction to the file (payment). But when I enter the Credit CardID to the transaction as the parent record, I need to populate the portal with transactions for that credit card that have not been matched.
I think this is in the realm of "so simple I am missing it". I am not using multiple tables, all transactions are in the one table.