Auto populate a lookup in a subform from a lookup in the parent form

Auto populate a lookup in a subform from a lookup in the parent form

Hello, I have searched through the forums and have found similar threads but not quite the same scenario as mine.

I have 3 forms,

ACCOUNTS (includes all contact information including "Company_Name")
ASSETS (Includes computer hardware information including a lookup from the Accounts form for "Company_Name")
FILES (includes a file upload field and a lookup for "Company_Name.")

The common field between all three forms is "Company_Name."

ASSETS includes a subform field using the FILES form.

My Goal: When clicking "Add New" in the FILES subform have the Company_Name lookup auto-populate based on the selection that was previously made in the Company_Name lookup of the parent ASSETS form (which is a lookup of the ACCOUNTS form)

The reason for doing it this way is I want to be able to have the FILES subform attached to the ASSETS form but still be a have it as separate searchable form.

I tried making sure the Company field used an "Existing" association but the the Account lookup is not listed under the ASSETS option when creating the association. The other "single-line" fields are available but not the lookup dropdown.

So, is there a way around this or should I be doing something differently?

Screen capture attached.

Thanks,

Bryan