>I'm running VFP5.0. I have a multipage form. I have several grids on the form. I would like to be able to append new child records in the grids.
>
>I am able to add new child records to the grids using an "ADD" button on the grids, containers. However, I would like to be able to add new records with either a mouse click on the TextBox (1st column) of the grid or an arrow down key press if a record already exists. I have tried to use the KeyPress method to accomplish this using code that is similar to the append blank code in the click method of my "ADD" button. It does append a new record in the table which I can see when I browse the table from project manager; however, it doesn't insert the "parent_id" and therefore doesn't show on the form. I have used "Replace parent_id with Parent.parent_id" following my Append Blank command (which works fine with my "ADD" button) but it appears to think it is on the same record and doesn't add the related "parent_id."
>
>Please help. TIA.
>
>--lincoln
Using INSERT-SQL to create new record, you shouldn't care much where is current record.
Edward Pikman
Independent Consultant