Roman Hausner wrote:
I do not seem to understand how one can create a form that would allow users to easily edit a many-to-many relationship involving three tables.
Let me give a simple example: there is table of departments, with name and departmentid, a table of persons with name and personid and a table that maps departmentids to personids.
What I would want is a from that shows department information (name) and a subform with a grid that shows all the persons working for that department.
The form should allow to easily add/delete departments and update department information, but also easily to add/delete persons for each department and also create new parsons (though the latter could maybe be moved to a different form).
Is there documentation on how to do this anywhere?
I might be wrong, but I think that you first define your main form. You can then embed a subform in each form. By default, the subform might key off of some field in the parent form to determine what to display.
It sounds to me like what you really want, however, is that when you are in the parent form, then the sub form ONLY shows entries for the focused item. When you move into the sub form, however, you want what ever is displayed to show only items that are related to items in the subform.... I suspect that you would have to use a macro to do this. I would recommend that you use two distinct forms and simply switch between them as desired/required.
That said, I would be interetested in your final solution.
-- 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]
