Ok I tried mandatory and got the same error message. If I remove it, no error message, but missing part of the list.
Which value is the default behavior left inner (mandatory) or left outer(optional)? Any idea what might be causing the error (see last post for "right join")? Is it possible that the optionality attribute has to be put in a certain order? Thanks, Mark ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
