Ask Your Question

Derived base Calc spreadsheets, does not work "Create query in the editor ..."

asked 2015-09-23 04:36:42 +0200

updated 2015-09-23 09:37:25 +0200

Alex Kemp gravatar image

(pt-br) Tenho um arquivo Calc com duas planilhas, criei um Base tendo como base esta planilhas, gerou corretamente as tabelas com os nomes das planilhas. Porém quando tento montar uma consulta que necessita relacionamento destas duas tabelas, em "Criar consulta no editor..." na janela aberta, "Adicionar tabelas" mostra as duas tabelas, mas ao selecionar uma e Adicionar a janela fecha, e não consigo incluir a outra tabela.

Isto é padrão, quando Base é derivado de planilhas do Calc, ou tem algo errado ????

(en-google) I have a Calc file with two worksheets, I created a basis based on this spreadsheet correctly generated tables with the names of the worksheets. But when I try to mount a query that requires relationship of these two tables, on "Create query in the editor ..." in the open window, "Add Tables" shows the two tables, but when selecting an e Add the window closes, and can not include the other table.

This is standard when Base is derived from the Calc spreadsheet, or have something wrong ????

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-09-24 23:18:04 +0200

m.a.riosv gravatar image

Hi Gilberto no error, it's no possible to do relations in Base with spreadsheets.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-09-23 04:36:42 +0200

Seen: 75 times

Last updated: Sep 24 '15