I'm working in VFP5.0a SP3 on NT 4.0. When I create a view - parent and two or three children - and browse the view, everything works fine. If I close the view, I get an error message saying "SQL: Column x_index not found", where x_index is the column linking parent and child tables. It is always the last link in the SQL statement which is named in the error message. If I save the view first, then close it, all seems fine until I attempt to modify the view, at which point the same error message appears, as well as having all links and field selection for the view dissapear. Inner, outer joins make no difference. Is this a bug or am I setting up the columns incorrectly? Since the view works if I save first, then close, and since it seems to work correctly, sometimes, as the basis of a report generated from that view, I'm thinking it's a bug, or that at the least it's 'designed behavior'. Does anyone know for sure, and in any case I'd like some workarounds/fixes, if possible. Thanks!