Hi Joe, please note that I answer your mail in [email protected], our project's mailing list [1], since questions like yours are best discussed in public: more people can contribute and potentially learn then. Please also reply to this list - thanks.
> I'm sorry if this question has been asked and answered, but can I link > two tables in Base, say by a common ID number and run a make table query? This depends on the database type you use. For the integrated HSQLDB engine, this is possible - you can define a relationship between the two fields of the two tables. Independent on this, you can always (again for HSQLDB) create a query which joins the two tables by exactly this field - just try the graphical query designer, where you have a "Insert/New Relation" menu item. Both might not apply to other database backend types, in particular, our dBase implementation does support neither relationships nor joined tables in queries. Ciao Frank [1] http://wiki.services.openoffice.org/wiki/Base_Mailing_List -- - 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]
