Display record from unrelated table

[bigmac]

I have 2 different tables.

I want to display a calculated value from table 1 in table 2. I first did this by making the value in table 1 global. Worked OK, but the value did not update correctly.

When i made it non stored calculation, I could not show the value because the tables were unrelated.

I have nothing to relate between the tables. There is no common denominator or anything.

The calculated value in table 1 is a get(TotalRecordCount) calculation that i want to display in table 2. How?

[DannyDK]

You could create a relationship between the two tables using the "x" relationship operator which basically makes every record in one table related to every record in the other table. It doesn't matter which field you use. Then, you should be able to see all global fields whether indexed or not.

[bigmac]

Thanks alot. Works great.