| Summary: | Relations between tables in base | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | l_marinchev |
| Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | d0m1n1k, robert |
| Priority: | medium | ||
| Version: | 4.2.4.2 release | ||
| Hardware: | Other | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
An archive with .jpegs
lookup menu in access |
||
could you please attach the odb too? neither 4.3 rc2 nor 4.4 dev show the described bug (at least not with a 1:1 relationship). i've just tried with a 1:n relationship, are you aware that the wizard finds the connection to the "n" table, when you select the "1" table in the first step? "i've just tried with a 1:n relationship, are you aware that the wizard finds the connection to the "n" table, when you select the "1" table in the first step?" - Yes that works. It's my bad, because i've always tried to make form-subform like this - Select "n" table for main form and "1" - table for subform. And one last question - Is there any function, when you create a table,that is similar to the "Lookup" menu in Access. Thanks for the help and sorry for the time loss.seleeseselect i think that there are use-cases for the inverse, so this could be a feature request ;) as there have been some winter's since i've used access the last time, could you provide a screenshot / description of what the lookup menu does? i've got a clue what it might be (and this is possible), but ... :) Created attachment 102387 [details]
lookup menu in access
The lookup menu makes it possible to change the column you can see in the related table and choose between the data in the other one.It also can add a listbox/checkbox in the table you want from a table/query you want.I,ve watched some videos about checkboxes in Form but it seemed a litle bit different.That's why i,ve wondered is that the only way to show data. i'm afraid you can't do this in the "table/data-view" of base, but you can create drop-down / select fields for a form, controlling (for example) the numeric value (id) but displaying the linked data from another table / select. as starting point i can provide http://listarchives.libreoffice.org/global/users/msg12693.html but there are more detailed manuals (which i don't have at hand). if you need more information, or a helping hand for the first form, just give me a hint. Thank you for the help and link.they were very useful. As I see the problem of the linked forms (one to many, not many to one) seems to be solved. Some feature-request are still there. But this should be reported in a new bug. Could be it's also no request if you see the difference between Base and Access and have learned to work with the functions Base provides. You could get the englisch Base-Handbook for download here: https://wiki.documentfoundation.org/images/e/e8/BH40-BaseHandbook.pdf It's a little bit older than the German original. I hope it would help you a little bit. I will close this bug as WORKSFORME. Feel free to reopen if you don't see it the same way. |
Created attachment 102157 [details] An archive with .jpegs Problem description: When I use Wizard to create a form, in the field "Set up a subform" it doesn't find an existing relationship between 2 tables. Steps to reproduce: 1. Create 2 tables and a relation between them 2. Start Wizard to create a from and select 1 of the tables which uses data from the other table.(I couldn't find a way to make table show a column, of the related table, I want.In Access you can choose which column to show.) 3.When I select to add a subform it doesn't find any relationship and offers me only manual selection of the fields. Current behavior: Doesn't show relations between tables in wizard (form). Can't find a way to make it show other column from the related table. Expected behavior: Expect to find relations between tables in wizard (form) and to has a way to work(show) with other columns from the first related table to the one I need.