>Yes, I can live with the "edit mode" too. I never had a handle on the "edit" >button approach. --- When you check GETFLDSTATE() are you checking the field >state of the records in parent table or the child table, or any/all table in >the in the database?
I would think it would have to be any/all fields you allow editing on the form.
>>Why not let the RI take care of adding child records when you add a new parent record? The same goes for deleting a record, let the RI take care of it.
>Won't this produce many blank child records. And if I'm not using a grid how >do I add additional child records to the parent? Or for that matter, children >of children?
IMO I don't like RI very much. Espicaly VFP RI, xCase has a better RI generator. So, for deletions I guess it is OK, but other than that you will want to control insertion of childern manualy. Sometimes parents are allowed to have no childern.
>I still don't follow the delete issue. If I can't pack the table how do I >prevent the data from appearing on thr form? How can I delete child records >without deleting the parent?
To stop deleted records from showing up use 'SET DELETED OFF'
Chad Gronbach
Blackstone, Inc.