>All,
>
>I have two file in a one to many relationship. I am trying to restrict insertion of records into a child table unless a parent record exists, but I have found that the act of inserting a record in the child causes the trigger to fail unless I have a dummy record in the parent with a blank key.
>
>Two question:
>
>1 Is there a way to insert a record in the child with the parent key already replaced?
>
>2. Is putting a dummy record in the parent the only way around this problem?
>
>TIA
>
>Rex
Rex,
1) Insert into child (pkey) values (parent.linkkey)
instead of append blank.
Or :
Child pkey default value something like :
iif(used("parent"), parent.linkkey, somevaluenotpossibleinparent)
then you could use append blank.
2) No as to the above :)
Cetin