Query Add Table Greyed Out
Query Add Table Greyed Out
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.
I reinstalled all over again but same problem.
Thaks for any help
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.
I reinstalled all over again but same problem.
Thaks for any help
Open Office 4.1.14 on Windows 11 64 bit
Re: Query Add Table Greyed Out
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Query Add Table Greyed Out
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.
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
Re: Query Add Table Greyed Out
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
Re: Query Add Table Greyed Out
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Query Add Table Greyed Out
I'm not sure here is an image of Table Info.
- Attachments
-
- vfp.JPG (70.12 KiB) Viewed 3131 times
Open Office 4.1.14 on Windows 11 64 bit
Re: Query Add Table Greyed Out
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Query Add Table Greyed Out
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.
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 (21.38 KiB) Viewed 2924 times
Open Office 4.1.14 on Windows 11 64 bit
Re: Query Add Table Greyed Out
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Query Add Table Greyed Out
Thanks Villeroy I will try via ODBC or forms .
Open Office 4.1.14 on Windows 11 64 bit