Hi all,

i'm looking for an example to show me:

1. invoice-Pos-Grid: how to get a Part-Number, -Price and -Text from
an Parts-Table into the current IB_Grid-Row with typing the Art_nr
and leaving the Part-Nr-field with enter.

2. To show data in a IB_Grid sorted to a Rownumber i use a trigger
like this:

lfs =invoice
lfspos =invoice-Positions
zeile =rownumber

CREATE TRIGGER BI_LFSPOS FOR LFSPOS BEFORE INSERT AS
BEGIN
UPDATE LFSPOS SET zeile = Zeile + 1
WHERE LFS_ID = new.LFS_id AND
ZEILE >= new.ZEILE AND
LFSPOS_ID <> new.LFSPOS_ID;
END

I would like to use the grid with its own delete/insert/append-
Functions.

How can i do these things?

Sure, this is not answered in 2 Lines.

Thanks in advance,
Christian