>I sometimes am not clear of what I mean. The
>information I want to populate the grid with is in
>it's own table such as the PRODUCTS table. I want
>to enter the product number in the first column of
>the grid (in a particular record), and a few other
>specified fields automatically populate. The
>records that would automatically popluate conatin
>information about the products number and they are
>in the products table, such as description, serial
>number, etc. It's kind of like putting in a
>customer number and getting the customer
>information to populate the form automatically.
Greg
Instead of usinf Grids why not use List combo boxes with multiple columns. In the Combo set source to SQL. In the Init() of the combo try this.recordsource = "Select * from...."
I have good results. You can use the fields in the resulting cursor from above to populate other fields.
The other problem, try looking in help under "Set Deleted" commnad.
I lost part of your message as you can see.
Tom