On Monday 22 January 2007 03:44, + Karl Krelove wrote: > [ MODERATED ] *********************** > 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? Sorry, I really do not use much of the Base functionality.
However maybe you should ask on [email protected](the database developers mailing list) and ask to be CC:ed as you may not see all replies unless you subscribe to that list by sending an email to [EMAIL PROTECTED] and reply to the confirmation request email. Please reply to [email protected] only -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
