While looking at the record itself, I tried to add a lookup to an existing column - couldn't find a way to do it. Access wants to Insert a new lookup column.
Ok, I'll go with that and then rename it. I made my lookup and whoa! great joy, it shows me what I want. Then I found I was unable to rename it from 'Field1.'
I Saved, reopened and bingo, the column 'Field1' is still there but the little drop-down for the lookup has gone.
What am I doing wrong? How hard can this be
Thanks - rev