>>>>
>>>>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?
>
> -dta

David,

Thanks for your reply. I'm working at coding the CREATE VIEW myself due to KB article Q157254, which states that there is a BUG in the SQL-SELECT when joining a parent to two child tables. The way the view designer builds the SELECT statement will cause the bug to show its ugly teeth. The workaround is to code the CREATE VIEW, whicn I am doing now.

Craig