I have a parent table Projects, a child parm-view PurchaseOrderEdit based on the table PurchaseOrder, and a grandchild parm-view POLineEdit based on the table PurchaseOrderLines. The parm-views have no defaults because the underlying tables do that at commit time. The PurchaseORderLine table has default on iID of NextID() for it's PK, and a default of ParentKey( "PurchaseOrderEdit.iID" ) for iPurchaseOrder it's link it's parent table.

If I:

use projects in 0
use purchaseorderedit in 0
use polineedit in 0
sele polineedit
append blank
brow

The real code in the form is a little more complex, but this code fails in the command window. I get the 1547 error on the browse. I really don't understand why. There are no table rules preventing the append.

This functionality has worked for all my other forms which are parent-child. This is the first form that is parent-child-grandchild.

Any and all help is appreciated.