<snip>

OK, let's form the question another way.

How would I create a VFP database relationship with the following criteria:

Case table has primary key column of Case_ID
InvHead table has primary key column of InvHead_ID
InvLine table has primary key column of InvLine_ID
InvLine table has foreign key of InvHead_ID with parent table being InvHead
InvLine table has foreign key of Case_ID with parent table being Case

InvLine.InvHead_ID column allows NULLs.
InvLine.Case_ID column allows NULLs.

InvLine may have no parent InvHead
InvLine may have no parent Case
InvLine may have both a parent Case and parent InvHead

When I create this relationship in Oracle or SQLServer it behaves just fine. The VFP Trigger code, however, if "restrict" insert rule is used, requires non-null values in foreign key column.

If I use "ignore" that seems too loose in that upon insert, any value could be used for the foreign key.

Jeff.