I was wondering if it's possible to get a value from a field in a collection based on an invoice number and show that value in another table?  

Scenario:  I have a collection which is used for uploading an invoice, so there will be values such as invoice number, invoice date, invoice amount, etc.  I have a table where the GL accounts are coded for each invoice and this allows multiple entries per invoice, so the invoice total can be split into separate accounts.  I would like to use formulas in the table to retrieve values from the invoice collection, based on the invoice number, so that each GL Coding entry can have the necessary values to store in the metadata, such as invoice date and invoice amount.

I have a template for the invoice information that includes multi-value fields for invoice number, invoice date, GL Account, etc.  The end goal is that when the invoices are saved to the repository, I want each invoice to have the metadata for each line of GL Coding.

Thank you for any advice.