Adding Tables to A Query

[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

[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.

[MValentine]

Sorry for the CAPS. I am working with dBase files.
Thanks for the quick response.

[DrewJensen]

Joins on dBase files is one of the more common feature requests - but unfortunately not implemented as of yet.

[MValentine]

Thanks again for the quick response.