Dynamic Calculation

[Genx]

Righto, basically what i have is a table which stores particular substitution codes and the fields to which they related... the idea is that these merge codes are substituted by the information of fields they are related to... now the substitute function works something like this... i never get the syntax right...

Substitute(Substitute(Related::Body

"<>"; help_field);

"<>"; help_not_field)

now the point is though, how do i do i add the codes dynamically using GetNthRecord or something?... if theres no way to do it dont worry, truth be told im just looking to reduce my workload a bit, anyway as always, thanks for any help.

P.s. the codes are in a related table.

Genx

Edited December 19, 2005 by Guest
vague...ness

[Ender]

Well, GetNthRecord() won't help here, but this custom function might:

http://fmforums.com/forum/showtopic.php?tid/120434/

[Genx]

Thanking you very much :

Genx