UpdateOrNewWithAttach

Takes four parameters, TableName, Relation, OtherTableName, IfLenFld

Usage:

TableName, Relation, OtherTableName, IfLenFld
TableName, Relation, OtherTableName, [""]
[WorkWith], Relation, OtherTableName, IfLenFld
[WorkWith], Relation, OtherTableName, [""]
TableName, Relation, OtherTableName, [WorkIf]
[WorkWith], Relation, OtherTableName, [WorkIf]

Description:

This combined Database command first checks to see if the Record already exists; if it does, then Update is called using TableName. If the Record does not alreay exist, New is called using TableName and then Attach is called.

The Relation parameter must be set to either "Child" or "Parent", and is in the context of what is OtherTableName to TableName.