>Have a database container with 8 tables. Trying to create a view using three tables. The Tables are related properly. Get the SQL: Column Fieldname error, but the fieldname exists in all the tables. What's going on? (using inner joins).
If the same fieldname exists in more than 1 table, you need to specify exactly which field you're trying to reference:
table1.fieldx vs table2.fieldx
Also, the view designer isn't so hot when working with more than 2 tables. Try using Erik Moore's "eview" which you can find in the files section here.