>>>
>>>This should be setup so that the user will enter a UserId to update and then a parameterized view will be populated. My question is, how do I create the view? I keep getting errors from the view designer that certain key linking fields can't be found. The exact field varies, depending on the order that I add tables to the view designer.
>>
>>did you try creating the view without the view designer
>>as you probably know the view as the query designer is less flexible than code
>>
>>Arnon
>
>That's the very next thing that I was going to try.

Craig,

I think you want to use more than one view for your form. One view displaying the One to Many side and the other showing the Many to one and then relate them to each other.

Does this sound like it might work? <s>

-dta