[Bug 124037] New: Can only select records from one table in creating a report or form

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=124037

            Bug ID: 124037
        Issue Type: DEFECT
           Summary: Can only select records from one table in creating a
                    report or form
           Product: Base
           Version: 4.0.1
          Hardware: PC
                OS: Windows XP
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: code
          Assignee: issues@openoffice.apache.org
          Reporter: ld_corey@yahoo.com
                CC: issues@openoffice.apache.org

When creating a Report or Form, I can only select the information from one
Table when I have multiple Tables. Using the Wizard to create the Report, the
previously selected information disappears from the window when the next Table
is selected.

I have established Relationships between my Tables.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 124037] Can only select records from one table in creating a report or form

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=124037

Andreas Säger <vi...@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |villeroy@t-online.de

--- Comment #1 from Andreas Säger <vi...@t-online.de> ---
Relations require a relational database.
Base is not a database at all. It is a limited tool to work with databases.
The (pseudo-) database you are working with is indicated on the status bar of
your database document. 
Spreadsheets, text files (csv) and other pseudo-databases don't have any
concept of relations. The built-in dBase driver does not support relations, but
other dBase drivers may. MySQL, PostgreSQL, the built-in HSQL and many other
database engines support relations and Base lets you create cross-table queries
on these databases.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 124037] Can only select records from one table in creating a report or form

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=124037

Regina Henschel <rb...@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |rb.henschel@t-online.de

--- Comment #3 from Regina Henschel <rb...@t-online.de> ---
MS Access is no complete database either, it uses the “Jet” database engine.

It is possible to use different tables. You need to use the "Form Navigator"
from the toolbar "Form Design". Depending on the database engine a form based
on a view might work too. I think, that this is not a bug, but support via
mailing list or forum is needed. There has been published a new database user
guide in LibreOffice project, based on a new German tutorial, which might give
additional relevant information too.
https://wiki.documentfoundation.org/images/e/e8/BH40-BaseHandbook.pdf

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 124037] Can only select records from one table in creating a report or form

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=124037

--- Comment #2 from Lance <ld...@yahoo.com> ---
So you are saying that Base is not a complete database like MS Access. So if I
install MySQL, I will be able to use Base to control the information. 
But that still won't allow me to place information from several Tables on the
same Report.

(In reply to Andreas Säger from comment #1)
> Relations require a relational database.
> Base is not a database at all. It is a limited tool to work with databases.
> The (pseudo-) database you are working with is indicated on the status bar
> of your database document. 
> Spreadsheets, text files (csv) and other pseudo-databases don't have any
> concept of relations. The built-in dBase driver does not support relations,
> but other dBase drivers may. MySQL, PostgreSQL, the built-in HSQL and many
> other database engines support relations and Base lets you create
> cross-table queries on these databases.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.