Trying to find an answer to this again ...
Does anyone know how to create a form for updating a many-to-many relationship in OO Base? I cannot believe that this should not work!
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]
