>I am creating an invoice form that has header
>records on the top of the
>form (vendor,invoice #,invoice date, total amount,
>etc.), and
>I need to have detail/line items for that header
>in a grid at the bottom
>of the form. I cannot get the grid to allow me to
>add more than one row
>to it! I have a link between the header records
>and the child records on vendor+
>invoice # (two files inv_head, and inv_detl). The
>best I have done is to get it to allow
>me to append a blank record to inv_detl, and add a
>line to
>the gri
Chris,
If I understand your form correctly, you are wanting a one-to-many relationship between your invoice control record and the invoice details. The grid displaying the child records (the detail) displays all details with the same invoice no. as its parent. To add a blank record requires that you insert a record in the bound table and that record have the invoice number. Consequently, if you want to have several blank detail rows displaying in the child grid, those records must all have the invoice number in them. You can insert multiple records into the cursor and not have them updated to the table if you SET MULTILOCKS ON and =CURSORSETPROP("BUFFERING","tablename",5).
hth
mike 8-)
Michael P. Haake
FoxPro Programmer
"Doing the best I can!"
** Retired Air Force **