Lookup wizard

S

Sean 35813

New Member

Joined

Nov 18, 2010

Messages

29

• Dec 23, 2010

• #2

Hi.

Go to Design view for a table. Go to the "Data Type" column for a field. Click on the drop down box for selecting the data type of that particular field. Lookup Wizard should be last option available.

 

Upvote 0

boblarson

MrExcel MVP

Joined

Nov 14, 2008

Messages

1,964

• Dec 23, 2010

• #3

ziad alsayed said:

dear all

i am new an access. i am using access 2010.
please advise om how to find the lookup wizard

thanks in advance.

Click to expand...

IMPORTANT!!!

DO NOT USE LOOKUPS AT TABLE LEVEL!!!!

See here for why. They should not be used there. You use lookups on FORMS but you don't set them up in tables.

 

Upvote 0

Z

ziad alsayed

Well-known Member

Joined

Jul 17, 2010

Messages

665

• Dec 23, 2010

• #4

thanks bob for the advice.

noted.

 

Upvote 0