I have tried things such as creating a list box that obtains its value using SQL as:
SELECT "Person"."PersonID", "Person"."Person" FROM "Person" WHERE "Person"."PersonID" IN (Select "Map"."PersonID" From "Map" Where "Map"."ProjectID"=?)
The first problem is.... How do you set the value for the question mark?
As I said before, this is a problem that I would like to solve, I am just at a loss for how at the moment.
Roman Hausner wrote:
Maybe I should make my question clearer and modify the example:
Lets say there are projects and persons. Each project can have several persons working on it
and each person can work for several projects.
I want a form that lets the user edit projects and show for each project the persons
working on it. In the same form, the user should be able to modify the
person information and to add or delete persons from the list.
I know how to design the tables for this:
*) there is table PROJECTS with a unique project ID for each project
*) there is a table PERSONS with a unique person ID for each project
*) there is a table PROJECTPERSON that maps person IDs to project IDs and has a unique key on projectID,person ID to avoid duplicate mappings of the same pair.
But what I do not understand is how to create a form that deals with these
tables in the correct way, so that I get the functionality described above.
I know this is possible in MS Access (without macros) ... is it also possible
in OO Base?
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm Free Info: http://www.pitonyak.org/oo.php
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
