> This is just a matter of my understabnding lookup. I have
> had the lookup working with PARTLIST joined to ORDER_ITEM so
> that DESCRIPTION from PARTLIST is is displayed linked to
> PARTNO. But in the final setup, I don't want the join at
> all, just the list of PARTNO to select the insert into the
> PARTNO field of ORDER_ITEM.

Assuming the main dataset has a field "PARTNO" and you want to lookup
a value "PARTNO" to fill that field.

LookupDataset
SELECT PARTNO,
DESCRIPTION /* if you want the desc in the lookup list */
FROM PARTLIST

KeyLinks: PARTNO=PARTNO
KeyDescLinks: <not needed in this instance>

OrderingItem: Part No=PARTNO ASC
OrderingLinks: PARTNO=1
OrderingItemNo = 1


LookupCombo
DataSource to lookup dataset datasource
DisplayField = PARTNO

> So the question is probably - how do I set up a simple list, or do I
> have to have the join?

The join is only required on the main dataset if you wanted to display
the description on the grid (and then you would maintain that
description using the KeyDescLinks). Presuming that the main dataset
actually uses PARTNO as its foreign key then the above should work as
required.

I tried something similar here and it does seem to work for me.

--
Geoff Worboys - TeamIBO
Telesis Computing