Hi Sepehr, > 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?
Do I understand your setup right that ReferenceID refers to some other (Items?) table, and that there can be multiple records in PrintList with the same MainID? In this case, it sounds as if you need a main form for the Main table, and a sub form for PrintList. Both should be linked via the MainID. Additionally for ReferenceID, you probably want to use a list box, which displays the names of the referenced (Items) table. > p.s. Is there a roadmap to fixing query problem (i.e. making them > editable)? No, sorry. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
