How to change data type to lookup wizard in Access 2002

[Donna]

I am taking a class on Access 2000 but I use 2002. In one
of the tutorials it asks us to change the data type of a
foreign key to "lookup wizard". When I do this I get and
error stating that the field is apart of one or more
relationships and that I cannot change the field data type
or size without deleting the relationship first. I need
instructions on how to create a lookup wizard and how to
restablish the appropriate relation ships so that the
lookup wizard will work.

Basicly the lookup wizard will lookup the customer number
automaticly by customer name. Customer name is the
primary key in the Customer table and the "many" side of
the relationship in the order table.

Also if I delete the relationship and I save the data It
will not change the data type for the table anyway.

Any help will be appreciated

Thanks

 

[Lisa]

Hi.

You will have to remove the relationship first in the
relationships window.

You said you primary key in the Customer table is Customer
name not number right? Typically "numbers" are used as
primary keys - not names, however, make sure the existing
foreign key field is the same data type as the primary key
in the Customer Table.

Then, in the Foreign key, choose lookup wizard from the
data type drop down list and just follow along. This WILL
NOT change the data type to lookup wizard - the data type
still has to be the same as the primary key field - but it
will now display a drop-down list in the field. (You have
to click in the field to see the drop down arrow in the
table)

Hope this helps
Lisa