I've got VisualMaxframe Professional 4.0. I have a navigational grid on the 1st page of a degridnav2pages form. The icMainalias table has 2 foreign keys for status and class whose user friendly names I want to appear in the navigational grid. So I set relations from the foreign key fields in the icMainalias to the corresponding indexs in the lookup tables. The relation lines appear correctly in the data environment. In the GrdNav.SetColumnControlSources method I typed

this.column5.controlsource = "ggstatus.sta_name"
this.column6.controlsource = "ggclass.classname"

the user friendly fields in the lookup table.

However when I run the form the status and class columns are all the 1st record in each lookup table. They are the same for all records, and that is inaccurate. It's as if the relation is not working.

If I insert a suspend and browse the tables individually the relation seems to work as the status and class tables move to their correct records as I change records in the icMainalias table. Then when I close the browse windows and resume the status and class columns seem to work correctly after that.

Why doesn't the relation work when I first load the form, and how can I make it work?

- Paul