NewTableRltn

Takes seven parameters, TableName, OtherTableName, ParentChild, Ratio, Note, Attr, DevNote

Description:

In the table specified by TableName, create a new relationship with OtherTableName.

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", "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."