Hi,
I am looking for a little guidance on an issue I am having with refreshing a form. The form is master-detail and it is the editable grid element that is not refreshing properly.
I have 4 fields, material, size, colour and cost. The field material is a combo box which looks up a value from another table. It also has the ajax EVENTS onChange set to update size, colour and cost and the Relaod form when value has changed is checked. The values to all fields are pulled through but are not relevant to the current value in the field material.
e.g.
The correct values are as follows:
[table]
[tr][td]Material[/td][td]Size[/td][td]Colour[/td][td]Cost[/td][/tr]
[tr][td]Glass[/td][td]10x8[/td][td]Clear[/td][td]100[/td][/tr]
[tr][td]Wood[/td][td]2x10[/td][td]Oak[/td][td]50[/td][/tr]
[tr][td]Steel[/td][td]8x4[/td][td]Stainless[/td][td]200[/td][/tr]
[/table]
Here are the values the form displays based on actions I perform
[table]
[tr][td]Action[/td][td]Material[/td][td]Size[/td][td]Colour[/td][td]Cost[/td][/tr]
[tr][td]Add record value Glass[/td][td]Glass[/td][td]null[/td] [td]null[/td][td]null[/td][/tr]
[tr][td]Change value Glass to Wood[/td][td]Wood[/td][td]10x8[/td][td]Clear[/td][td]100[/td][/tr]
[tr][td]Change value Glass to Steel[/td][td]Steel[/td][td]2x10[/td][td]Oak[/td][td]50[/td][/tr]
[/table]
The form values always seem to be a step behind the value selected in the material field. The values recorded in the table are the same as those on the form.
If I go back to the record and click edit row the values for size, colour and cost are immediately corrected to the values that should be displayed.
Any help would be appreciated.