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.