I have a combo box that is linking improperly or so it seems. I have done this a thousand times but this one just won't link properly..

Row source is Lookupdata.description
Row source type is Alias

Controlsource is master.id

interactive change updates master.id with lookupdata.id.

Report links fine but form shows different description.

I have both tables in the data environment of the form and link master.id to lookupdata.id

This is driving me and my users crazy. I have other combo's on this page that works fine.

What could I be missing?