Adding a lookup to a column

[revnice]

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

[fanzak]

Once you have created a Field and you forgot to make it (straight from the beginning) a lookup field, you can always go to Field Properties, and at the bottom of your screen, you should find a tab "Look Up".

[revnice]

Thanks - I'll check it out.

[revnice]

I checked it out.

The Properties for the CUS_NUM column look fine (see pics) and it worked in Design View, but back in the record itself there's no little drop-down thingy.

What next?

[revnice]

I think I hadn't clicked in the field, that's what makes the drop-down appear. I'll take a Darwin Award for that...

But check this out (pics). I've specified two columns in my combo lookup - but the drop-down only shows me one.

What's with that?