I'm having some puzzling difficulty in working with queries. I have two tables, one with student data (names, addresses, phone numbers, school, room, etc.. The other table has grading data for each student in my class. The tables are linked by a student ID number that is common to both tables. Each table has a primary key.
I can edit data in a query based on only one table. If I include a second table in order to see data from both tables for each student, sometimes I can edit when I run the query and sometimes I can't. It seems sometimes to depend on what type of join I use for the connection between the two related fields. Sometimes, none of the three types allows me to edit data. Sometimes right joins do and inner or left joins don't. I've lost track of all my experiments, but it seems to me that I've built identical queries with the same relationships between tables and sometimes they allow editing and sometimes they don't. If I try to add a third table (for example, a table holding the school numbers that are in the student data file and the full name and phone number of the school). This third table is related directly to the student data table through the common field and indirectly to the class data table through the student data. I've read in some postings that there is a bug in OpenOffice Base that causes editing data in queries to be problematic. Is this really the problem, or am I missing some basic rules about queries in OpenOffice that would at least make the problem seem more systematic. I find that forms behave the same way the queries on which they are based behave and, I think, the same for "views" (which seem to me to be the same as queries but in the Tables section). Any ideas to make sense of this? Thanks. Karl Krelove --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
