Hi, I'm trying to generate a simple form that allows you to set a value in a referenced table that may or may not have referencing fields. If queries would allow data editing this would be simple, but this appears to be a feature/limitation/bug. Here's a simple example:
Table1: Main Field 1: MainID (this is the main index) Field 2: Name Table2: PrintList Field 1: MainID (this the index for this table) Field 2: ReferenceID Field 3: Print (this is a boolean field) Now I have lots of records in Main and I want to query all the records from Main an those from Printlist where MainID match. PrintList starts out basically empty. I want to have form that I can now go through all of Main and select items to add to the PrintList. When I select it would add the record if it does not exist. This is a simple query to build either native or not but OOo makes all queries readonly. I have fooled around with subforms with no success. Any suggestions? Note I'm using Postgresql on the backend. p.s. Is there a roadmap to fixing query problem (i.e. making them editable)? thanks, -- ===================================== Sepehr (Sep) Kiani, Ph.D. Email: [EMAIL PROTECTED] http://pergatory.mit.edu/skiani =====================================
