We are using sub-forms in modules. They are great for recording status and dates of contractor invoices and works. However, there are some functions that we want to use that do not seem possible with the sub-forms:

1. We need to see certain fields from the sub-forms in the Module List view eg. Status Updates

2. We need to show certain fields in Reports eg. Invoice and Bill amounts, Status, Dates etc.

3. Workflows that act on changed data within the sub-forms.

It looks like none of this is possible. Is there a way to incorporate this data? It is such a shame to have the sub-forms but we can't do anything with the data.