>I have a dropdown, RowSourceType="6-Fields", RowSource="Myalias1.field1, field2", BoundColumn=2, ControlSource="MyAlias2.Id".
>
>Field2 is integer type and is an indexed field.
>MyAlias2.id is integer type field and is an indexed field.
>
>As long as I don't delete anything from MyAlias2, the dropdown displays the correct record. As soon as I delete a record from Myalias2, the dropdown starts to display wrong record or not display anything at all. What am I doing wrong and how can I fix this.

Make sure BoundTo = .T.