0 Replies Latest reply on Oct 6, 2011 3:30 PM by philmodjunk

    An Improved Many to Many Demo file



      An Improved Many to Many Demo file


      Ok, been working on this off and on for a while. This post contains a download link illustrating how to implement a many to many relationship and then also demonstrates two alternative methods for making the necessary links between the two tables.

      In addition to using a portal to the join table, there is also a layout where a diminishing value list is implemented as a way to keep the user from linking the same pair of records more than once. A third layout sets up a portal as a check box controlled list as yet another way to make linking selections between the two tables.

      Each layout is copiously annotated. Notes have been included in the relationship graph--which is set up in Anchor Bouy format. Comments have even been added to some field definitions to help folks figure out how each part of the system works.