Maureen:
I don't know why you should be getting the error, but I'd simply advise you
never to use the lookup wizard. Its generally regarded as worse than
useless. For some reasons why take a look at:
http://www.mvps.org/access/lookupfields.htm
In table design view merely select the data type appropriate to the actual
data in the field. This will usually be a number of long integer type which
references a long integer primary key (often an autonumber) of the referenced
table. To see the value from the other table use a combo box on a form;
which is where data should be entered and edited, not in raw datasheet view.
The combo box wizard can set it up for you, but its easy enough to hand-craft
it. Say for instance you have a field CityID in a Customers table and on a
Customers form you want to be able to select a city by name from a Cities
table the combo box's RowSource property would be like this:
SELECT CityID, City FROM Cities ORDER BY City;
and its other properties would be like this:
ControlSource CityID
BoundColumn 1
ColumnCount 2
ColumnWidths 0cm;8cm (or rough equivalent in inches but the first
dimension must be zero to hide the first, CityID, column, so only the name
shows)
Ken Sheridan
Stafford, England
