A table in multiple relationships can only have one child order (Error 1889)

You have specified more than one child order for a table in multiple relationships. This operation is not allowed.