Frank, Thanks for the reply. Ok I see what I wrote is a bit confusing. No the intention is that there is a one to one relationship between the two tables. Just delete ReferenceID field, it was just an index for this table. Main:MainID to PrintList:MainID. I want to have a form that lists all the contents of Main and has a check box column for PrintList:Print. I want to be able to scan through the entire Main table (in a particular order) and select items that I will print by selecting them. Suggestions?
thanks, -- ===================================== Sepehr (Sep) Kiani, Ph.D. Email: [EMAIL PROTECTED] http://pergatory.mit.edu/skiani ===================================== On 1/18/07, Frank Schönheit - Sun Microsystems Germany < [EMAIL PROTECTED]> wrote:
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]
