I have created a form which references a database MMGAUGE. This database is related to two other databases. I have the statment CURSORSETPROP("Buffering",3) in my form's INIT method.

SET RELATION TO gaugeid INTO gauges ADDITIVE
SET RELATION TO disease INTO mmdisease ADDITIVE

I have a text box on the form where the control source is MMGAUGE.GAUGEID. I have a combo box on the form where the control source is MMGAUGE.DISEASE and the rowsource is MMDISEASE.DISEASE. This combo box displays the correct information as I skip to each record in the database. I am trying to add a combo box with the control source set to MMGAUGE.GAUGEID and the record source set to GAUGES.GAUGEID. When I run the form, the new combo box displays the incorrect GAUGEID. It seems to display the next record in the GAUGES table. I check the relationship and it seems to be fine. What I am doing wrong?

Thanks