How to change data type to lookup wizard in Access 2002

  • Thread starter Thread starter Donna
  • Start date Start date
D

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
 
In one
of the tutorials it asks us to change the data type of a
foreign key to "lookup wizard".
Click to expand...

I suggest you get yourself a new course, or a new tutor. The use of the
lookup wizard is strongly deprecated by just about everybody here, and you
would be well advised to steer well clear of it.

It sounds as if you are setting up the tables and relationship correctly
anyway, although I would not normally recommend using a Name as a Primary
Key -- what happens when you get your second John Smith? I would suggest
that you create the look up table and set the relationship by hand, so that
you remain in control of what goes where.

All the best

Tim F
 
Back
Top