Newbie Question

[kilikina]

I have two tables and would like the calulated value in a field in Table 1 to appear in a field in Table 2. How do I do this?

Is it a match field?

Script?

thanks :)

[Inky Phil]

....like the calulated value in a field in Table 1 to appear in a field in Table 2.

Do you really need to have the same piece of data appear in 2 tables? Why not just establish a relationship between the two tables and use the data from table 1 in table 2?

Indeed if the field in table 1 is a global field you can use it in table 2 without a relationship.

Anyway, to answer your question directly, establish arelationship between the two tables and then set the field in table 2 to be a calc field, (result same type of field as field in table 1) with the calc:

yournewrelationship::fieldintable1

set the 'do not store recalc as nec' box if applicable

HTH

Phil