4 Replies Latest reply on Jul 22, 2015 3:38 AM by PhilEvans

    Join Tables and Portals



      Join Tables and Portals



      I hope someone can point me in the right direction with this:

      I have two main tables:

      ServiceUsers and Services

      Many ServiceUsers may use many Services and many Services will have many ServiceUsers (many to many relationship)

      My add/edit ServiceUser form has a drop down that pulls a Services ID to a Services FK in my ServiceUsers table. All good.

      However - I have tried to resolve the issue of many to many issue by adding a ServicesUserJoin table with FKs for Services and ServiceUsers and set the relationship between ServiceUsers to create a record in the join table.

      My first problem is when I create a new ServiceUser and add the related Service, no record is being created in the join table.

      Secondly I seem unable to display related records in a portal - I need to display a portal that shows all ServiceUsers in the Service layout and vice versa. Nothing seems to work.