how to auto populate rows into subform from another form?

how to auto populate rows into subform from another form?

I have the following forms:

Main
Files (subform)
Upload

Both forms  Main and Upload have a Subform linking to the form Files

The form Files has a bidirectional relationship to form Main.

A custom action in the records of the form Main opens the form Uploads which contains the subform Files

Both Main and Uploads are none stateless forms.

Currently when you click the custom action and submit the form with subform Files the records will appear in the Main form when you edit / view the records.

I want a way so that when I click the custom action button again, after already submitting the form once, for it to show all records submitted in the subform Files previously.

I tried adding a second bidirectional relationship to the Upload form but this does not seem to work. I think you can only have one bidirectional relationship?

How can i get a subform to show the records in another form?
How can i also be able to remove and add rows and have it update the Main form?




Currently if i submit the upload form a second time it just adds more records to the Main form. This is good but I want to be able to view what has already been uploaded and remove rows from this form in the Main form.

Maybe there is a better way to do this?

I though of just allowing a custom action to edit the Main record but i would need to hide everything except the Upload subform and cant see how to do this in a custom action for editing the record.

Any help / direction would be much appreciated.

Thanks
Matt