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.