Often when trying to show data from two or more records of the same type in another record, the answer is another table.
AccountStatus Table related to Invoices Table would allow this.
The relation between AccountStatusID and InvoiceStatusID would easily allow showing status for mulitiple invoices in one record.
Similar to an Invoice showing mulitple Product Name, Number Ordered, Price, Total Price in a LineItem portal in Invoice.
Thank you . For some reason I had completely forgotten that I could use a portal to show a single field...