I've got two tables that are in rel

[augustin]

I've got two tables that are in relation (one-to-many).
First, doctors (master) and schedule (child).
In a form, I have a combo box where I select a doctor(from table doctors) and a grid where is diplayed the corresponding schedule of the doctor selected in combo box ( from schedule).
Of course, in the form I've got other controls but these are not important in this case.
First time when I've created this form the results in the grid were correctly displayed, but after some developments of the form I observed that the results in the grid are not what it should be. More precisely, in the first row of the grid is displayed the correct data and in the next rows, the data corresponding to the next doctors of the doctor selected in the combo box.

 

[kazl]

Hi

Just an idea...

Have you made sure that you have the parent table selected when the grid is displayed?

You might need to select the parent table, set the relation, then show the grid. When the child table is the currently selected work area then the grid does not display the right data.

 

[augustin]

The relation between the tables are made in the data environment of the form. I don't understand why first time was O.K.( when I created the controls, combo and grid ) and then( after developments of form ) was not O.K.
So, I select a doctor in combo box -> the grid display in the first row the corresponding data and in the next rows the data corresponding to the next doctors of the doctor from combo box. The grid should display only the data corresponding to the doctor selected in combo box.