General information
Category:
Coding, syntax & commands
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only