General information
Category:
Forms & Form designer
Title:
How to control record pointer in grid
I am trying to develop an entry form with two DBF
SALEMAST.dbf(parent) and SALEDET.dbf(child) with
joining field INVOICENO and Child table contain another field Itemcode
The SALEDET is attached to GRID but the grid contains no column with
INVOICENO field. and Allownewreocrd property is set to .T.
At the begining when I add record to parent I append a blank record
to the child and replace child INVOICENO field with Parent INVOICENO
field.
And when entering record in GRID with DOWN ARROW, I again replace the
child INVOICENO field value with parent INVOICENO field.
Upto this, it is working fine.
But I don't what any record in child table with blank Itemcode
Now when I am at the last row of GRID with blank Itemcode column -
if I key in UPARRROW - I use tablerevert(.f.,'saledet')
and record pointer move to the above row.
But if I key-in DOWNARROW, then again tablerevert remove the record
with blank itemcode but record pointer move to EOF() and
grid contains no row.
Suggest me some solution.
Aritra
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only