Page 1 of 1

Adding Tables to A Query

Posted: Sat Jan 19, 2008 5:28 am
by MValentine
I AM TRYING TO CREATE A QUERY. I HAVE ADDED ONE TABLE NOW I WANT TO ADD A SECOND AND POSSIBLY A THIRD TABLE TO THE QUERY. I SEE THAT THEIR IS AN ADD TABLE BUTTON. HOWEVER THE BUTTON IS GRAYED OUT AND NOT ACTIVE IN MY QUERY. HOW DO I ADD ADDITIONAL TABLES TO THE QUERY? I AM NEW TO OPENOFFICE-BASE. MY EXPERIENCE IS WITH MICROSOFT ACCESS.

THANKS FOR THE HELP

Re: Adding Tables to A Query

Posted: Sat Jan 19, 2008 5:34 am
by DrewJensen
Hi,

First - could I ask you to turn your caps lock off...it is a bit much.

Well, that button is grayed out when you are connecting to data sources that do not support joining tables. This includes any of the flat file data sources - dBase, Spreadsheets, Text files, Address books.

If you are actually connected to a relational database ( e.g. You created a default Base file with an embedded database ) it should not be.

Re: Adding Tables to A Query

Posted: Sat Jan 19, 2008 5:36 am
by MValentine
Sorry for the CAPS. I am working with dBase files.
Thanks for the quick response.

Re: Adding Tables to A Query

Posted: Sat Jan 19, 2008 5:39 am
by DrewJensen
Joins on dBase files is one of the more common feature requests - but unfortunately not implemented as of yet.

Re: Adding Tables to A Query

Posted: Sat Jan 19, 2008 5:41 am
by MValentine
Thanks again for the quick response.