Adding a Lookup Field to an Access 2010 Table

gettingready

Hiya,

Can anyone point me where to find instructions (with screenshots) for this topic please?

All I can find is based on Access 2003 and 2007 and I need this topic on Access 2010.

Even the youtube videos say 2010 but screenshots are from 2007 and 2003.

Can anyoen help please?

Need for.. today

Can be based on Northwind, just need the "how to" instructions for:

Adding a Lookup Field to an Access 2010 Table

Thanks a million if anyone can help....

gettingready

Anyone? Please?

All the links I can find say 2010 but the screenshots inside and instructions are for 2007 and 2003, you can see it on the title bar cleary says 2007 or 2003 and NOT 2010 - can not find anything (instructions with screnshots for 2010 at all)

UsernameAlreadyExists

"Sorry as a new user you are not allowed to post with links. This is done to stop spammers clogging up the site. Please edit your message below to continue."

Well that's useful


try reassembling this?

http://
answers.microsoft.com/en-us/office/forum/
office_2010-access/access-2010-change-field-to-being-a-lookup-field/
efa8f1fa-b974-4fa4-80dc-4a817ac2d5b6

I've not used Access myself for years, but a quick skim seems to indicate that it's relevant.

gettingready

Thanmks - I have not used Access since.... 2004.. never ever even opened 2010.

Thanks for the link but it needs to be about creating one from scratch not changing one - grrrrrrrrrrrrrrrr I am so upset.....:(

Been searching for so long and a lot of titles coming up on search say 210 but then screenshots are clearly from 2007 or 2003 and I can forn NOTHING on 2010 that explains what I need in complete step by step....

Buuuuu

johnmc

Why are you doing it in the table?

The data should be out of sight of the user and definitely should not be editable.

Put the lookup on a form.

gettingready

It is not my idea, it is what is requested - exactly as per title ...

Still have not found what I need

gettingready

sorted.. sigh...