Refreshing related values

[Jarvis]

I'm working on a database for my cabinetshop.

I have two tables.

Table 1 contains the calculation fields I use to dimension cabinet parts.

Table 2 holds parameters which are used in some of the calculations. I keep all the parametric information in one table so that it is easier to find and manage.

An example of a parameter might be how much we want to trim down from a cabinet door after we build it. Today we typically trim 3mm from each side. If technology changes in the future I can change this value on the parameter side.

The two tables are joined with a match field that is always set to match.

The problem I am having is that when I revise a field on the Parameters Table the change does not automatically update on the Calculation Table.

The change will show up if I click into the field but not unless I click into the field.

[color:red]Is there a way to automatically toggle fields on the calculation side so that they refresh each time I update a field on the parameter table?

Thanks for any direction here,

Jarvis

[Søren Dyhr]

These refreshing issues is often due to a wrong positioning of a global field, evaluations are usually shortcut if values are picked over several relational jumps.

See if anything we discuss in this thread has anything to do with your problem:

http://fmforums.com/forum/showtopic.php?tid/201267/fromsearch/1/tp/0/all/1/

--sd

[Jarvis]

Thanks Soren,

I found my answer in that thread.

If I run the script step: "Refresh Window" the problem is solved.

[Søren Dyhr]

I found my answer in that thread.

If I run the script step: "Refresh Window" the problem is solved.

However could you by this be curing an inadequate relational structure ... I would not be pleased if thats the case here as well?

--sd