PDA

View Full Version : Linking Fields between tables



cadmancando
2007-05-07, 06:12 PM
Anyone have any success with this?

zoomharis
2007-05-08, 10:42 AM
Can you tell us what exactly you are trying to achieve, if possible with an example?

cadmancando
2007-05-09, 06:42 PM
Sure.....

I've created a table, which has a sum field at the bottom.

I have another table on another layout which has a field which looks at the first tables summary field and places the same value in the second table.

I guess I could say...."I want to link a field in one table with a field in a second table"

Hmmm....

Idea maybe....

Can you use a diesel expression to set the setvar USERR1 to the value of the first field?

Then I can retrieve the USERR1 value to the field of the second, third, .... table(s)

cadmancando
2007-05-09, 08:22 PM
Figured it out....

The field of the second table must state:


=Table(2130252600).A5

where

2130252600 = Table ID

A5 = Field of table