Query Add Table Greyed Out

Creating tables and queries
Post Reply
Synapsis
Posts: 6
Joined: Thu Sep 28, 2023 1:53 pm

Query Add Table Greyed Out

Post by Synapsis »

Hi
When I try to make a query when I select the first table and click "ADD" the table is added and the windows closes.
If I try to use F7 or Insert Add Table the option is greyed out.
To put it short I can not select multiple tables for my query. :crazy:
I reinstalled all over again but same problem.
Thaks for any help
Open Office 4.1.14 on Windows 11 64 bit
Top
FJCC
Moderator
Posts: 9574
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Query Add Table Greyed Out

Post by FJCC »

What is the source of your data? Is it a spreadsheet or a table in an embedded HSLQ database or something else?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Top
Synapsis
Posts: 6
Joined: Thu Sep 28, 2023 1:53 pm

Re: Query Add Table Greyed Out

Post by Synapsis »

Sorry I left out my source they are dbf from FoxPro. So I tried creating a new table inside of dbase but still the same problem, after selecting the table then click add the window closes and I can not add or select another table.

Just wanted to add that I can do queries on the dbf file without any problems but only at a time.
Open Office 4.1.14 on Windows 11 64 bit
Top
Synapsis
Posts: 6
Joined: Thu Sep 28, 2023 1:53 pm

Re: Query Add Table Greyed Out

Post by Synapsis »

OK just tried a new dbase and created two tables and it works. So it has something to do with the FoxPro dbf files.
Open Office 4.1.14 on Windows 11 64 bit
Top
FJCC
Moderator
Posts: 9574
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Query Add Table Greyed Out

Post by FJCC »

Do the tables that don't work have a primary key?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Top
Synapsis
Posts: 6
Joined: Thu Sep 28, 2023 1:53 pm

Re: Query Add Table Greyed Out

Post by Synapsis »

I'm not sure here is an image of Table Info.
Attachments
vfp.JPG
vfp.JPG (70.12 KiB) Viewed 10997 times
Open Office 4.1.14 on Windows 11 64 bit
Top
FJCC
Moderator
Posts: 9574
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Query Add Table Greyed Out

Post by FJCC »

I can't tell for sure from that image since I'm totally unfamiliar with that interface. The grey Indexed box makes me suspect there is not a primary key, since a primary key would make a Unique index. From Base, if you click the Tables icon in the leftmost column, right click on the table and select Edit, is there a small yellow key icon just to the left of any of the Field Names?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Top
Synapsis
Posts: 6
Joined: Thu Sep 28, 2023 1:53 pm

Re: Query Add Table Greyed Out

Post by Synapsis »

Hi and thanks for your help. No when I edit a table there is no yellow icon just the green triangle for the row selected.
There are fields IDAUT which are [Interger] which could be the key.
So you think that not having a key could be the problem?

When I try using the wizard after adding the fields from two different tables I get this message.
Attachments
query.JPG
query.JPG (21.38 KiB) Viewed 10790 times
Open Office 4.1.14 on Windows 11 64 bit
Top
User avatar
Villeroy
Volunteer
Posts: 31349
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Query Add Table Greyed Out

Post by Villeroy »

The dBase driver of LibreOffice does not support relations. However, it is possible to edit related data by means of forms and subforms. You may try a 3rd-party driver via ODBC.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Top
Synapsis
Posts: 6
Joined: Thu Sep 28, 2023 1:53 pm

Re: Query Add Table Greyed Out

Post by Synapsis »

Thanks Villeroy I will try via ODBC or forms . :super:
Open Office 4.1.14 on Windows 11 64 bit
Top
Post Reply

Return to “Tables & Queries”