<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.
------------------------------
Jeff King