Adding Tables to A Query

Creating tables and queries

Adding Tables to A Query

Postby MValentine » Sat Jan 19, 2008 5:28 am

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
MValentine
 
Posts: 3
Joined: Sat Jan 19, 2008 5:21 am

Re: Adding Tables to A Query

Postby DrewJensen » Sat Jan 19, 2008 5:34 am

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.
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
User avatar
DrewJensen
Volunteer
 
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA

Re: Adding Tables to A Query

Postby MValentine » Sat Jan 19, 2008 5:36 am

Sorry for the CAPS. I am working with dBase files.
Thanks for the quick response.
MValentine
 
Posts: 3
Joined: Sat Jan 19, 2008 5:21 am

Re: Adding Tables to A Query

Postby DrewJensen » Sat Jan 19, 2008 5:39 am

Joins on dBase files is one of the more common feature requests - but unfortunately not implemented as of yet.
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
User avatar
DrewJensen
Volunteer
 
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA

Re: Adding Tables to A Query

Postby MValentine » Sat Jan 19, 2008 5:41 am

Thanks again for the quick response.
MValentine
 
Posts: 3
Joined: Sat Jan 19, 2008 5:21 am


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 2 guests