Jump to content
Sign in to follow this  
kilikina

Newbie Question

Recommended Posts

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 :)

Share this post


Link to post
Share on other sites

....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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.