Takes eight parameters, TableName, OldOtherTableName, NewOtherTableName, ParentChild, Ratio, Note, Attr, DevNote

Description:

In the table specified by TableName, update the relationship named RltnName with the new specified values. If the relationship is not being changed from one table to another, OldOtherTableName and NewOtherTableName should be identical.

• OtherTableName is plain text
• ParentChild must be one of: Parent, Child, Circle
• Ratio must be one of: 1-1, 1-m, m-1, m-m
• Note is multiline text
• Attr is delimited by the builtin value of $I for each value
• DevNote is multiline text

All fields need their data to be submitted as escpated HTML using the WebSafe$. When using the ListProcs command, the data is returned in this format already. Also, any data submitted via a URL parameter or URL encoded form data to Moxie has WebSafe$ applied automatically.

Example:

NewTableRltn "MemTab.Person", "MemTab.Contact", "MemTab.Contact", "Child", "m-m", "Shared contact records serve to group people into households", ("[Update]" & $I & "[Sort] Type"), "Type values need to be sortable alphabetically if we take this approach."