Modify default table view - add data from another table?

Modify default table view - add data from another table?

Hi -- I've been at this for about a day now and I have not had any luck with this. Here is the scenario:

Form 1 - Contains a list of Companies (e.g., Nike, Addidas, Reebock).
Form 2 - Contains a list of store locations for each of the companies in Form 1.

When displaying the table view for Form 1, I would like to display a new column that shows how many total stores are available for that company.

I wrote a very simple function to query the data:
    LC = Locations[Company_Name == input.COMPANY_NAME].count();

The script works perfectly.. when I try to execute it, it returns the correct data.

My problem is being able to call that function, or somehow getting that data, into the default Form 1 table view. Is this even possible?

I've tried putting the function call (and even the code directly) in the Form Definition area. I've also tried putting it in the Page Load, but that doesn't work since there is no reference row.

Is there a way to accomplish this without creating a custom HTML view?

thanks!