Hello Joe,

> OrderingItems
> ========================
> Make=SERIALS.SERIALMAKE
> Model=SERIALS.SERIALMODEL
> SerialNum=SERIALS.SERIALNUMBER
> DateReceived=SERIALS.SERIALDATEREC
> Cost=SERIALS.SERIALCOST
> Notes=SERIALS.SERIALNOTES

The OrderingItems are OK.

> OrderingLinks
> ========================
> Make=ITEM=1
> Model=ITEM=2
> SerialNum=ITEM=3
> DateReceived=ITEM=5
> Cost=ITEM=4
> NotesITEM=6

But the OrderingLinks must mention the field names from the SQL
instead of (Grid)DisplayNames or OrderingItem names, like this:

SERIALMAKE=ITEM=1
SERIALMODEL=ITEM=2

etc.


If you're in the SQL Editor during design, click Create near the
bottom of the OrderingLinks tab and both OrderingItems and
OrderingLinks will be created for you (including descending
orderings). You can always edit them if you want to do some
finetuning.


HTH,
Paul Vinkenoog