>I have read about the problem before, but don't remember what I have to do to
>get around it. In the view designer, I have three tables, one parent and two
>children. Upon closing the view designer, I get the message 'SQL: Column
>'myfield' not found.' The field is obviously in the table, but the view
>designer is getting confused because of the order it has joined the tables or
>something. Had this problem before? How do you get around it? I have already
>adding and joining the tables in a different order, no help. Thanks in advance.

Either write the code by hand (CREATE SQL VIEW ... AS ...), or use the Filter tab to do the joins, rather than the Join tab.