>I commonly display, edit, and add child records in a grid of a form that also displays a record of the parent. When adding, I get the parent key, then INSERT INTO childtable(parentkey) VALUES parent.keyvalue. That works fine. But I was thinking, for absolute prevention of orphans, maybe I should give the parentkey field of the child table the default value parent.key. Or maybe that's a bad idea. The parent table would have to be open, and not at EOF(). If the child was actually a child of two tables (relating them many to many) then both tables would have to be open. Maybe a stored procedure could take care of this stuff. Is this all a good idea generally, and, if so, what do I need to watch out for?
Basically, it's routine job for RI INSERT trigger.
Edward Pikman
Independent Consultant