To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=12329
------- Additional comments from [EMAIL PROTECTED] Mon Aug 8 00:50:59 -0700
2005 -------
I wanted to point out another facet of the problems that linking subforms to
forms does not work with more than one parameter.
Consider a database which has two tables, projects and employess and a
relational table linking these tables which stores, say, assignments of
employess to a project for some quarter and to a certain percentage.
The classic DB design to represent this is the following:
PROJECTS PROJECT_ID PROJECTNAME
0 Project 1
1 Project 2
2 Project 3
EMPLOYEES EMPLOYEE_ID NAME
0 JACK
1 JOHN
2 JIM
ASSIGNMENT PROJECT_ID EMPLOYEE_ID QUARTER PERCENTAGE
0 0 1Q05 80
1 0 1Q05 20
0 1 1Q05 100
... and so on ...
I would like to build a form, which allows me to select both a project and a
user, and then to enter assignments for this combination of project/user into
the database.
No matter how you build your form, you will always end up with a query which
requires two parameters to select the correct row of the ASSIGNMENT table. One
parameter is bound to a PROJECT_ID value of the PROJECT table, the other is
bound to an EMPLOYEE_ID of the EMPLOYEE table.
What I observed is that both parameters in the query are set to the same value,
in my case always the project ID value. (I suspect that it is always the value
of the parameter specified first...)
Note that I was working with version 1.9.122!!!
I strongly suggest to change the priority of this issue to at least P2, because
if it is not possible to build such basic forms using BASE, its usefulness is
very questionable.
-- markus, looking forward to a quick solution
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
