updating calculated fields in another table

[sunkissedeyes]

i have a calculation that is working fine when i create the record. but when i change the data (a date) the the other field which has a GetAsDate function as the calculation.

NOT WORKING

[table 1] date_1

[table 2] date_A calc (get date from table 1 date_1 field)

the calculation is not stored.

if i put the field in the same table it works, so it seems like it maight be a relationship issue. the tables are linked via their Job# being the same which i verified as such.

when i make a similar field in table 1 it works, but that's not so helpful.

WORKS

[table 1] date_1

[table 1] date_2 calc (get date_1 from table 1)

i feel like i must be missing something very simple.

[Twd70]

if you check in the calculation of table 2's date in the bottom left is the format. just check it is set to date as if its not set the same as the field it is GetAsDate-ing from it wont work.

you did say something simple and simple is all i know atm.

otherwise try a LookUp function?

= LookUp ( Table1::date1 )

again check the format.

good luck

[sunkissedeyes]

thanks for the ideas...

the fields involved are all specified as 'date'.

i tried lookup but it didn't work either.

i did make a script and attached it to a button and it worked.

but i'd prefer the fields to be update without any user intervention.

[Twd70]

well it seems ur calculation fuctions are broken and my script functions are dead. see here:

http://fmforums.com/forum/showtopic.php?tid/180942/post/224142/hl//

could use a portal as a last resort i guess but thats a bit pants

[sunkissedeyes]

not sure what you mean...

the link doesn't work for me.

which post are you referring to?