0 Replies Latest reply on Nov 17, 2015 1:14 PM by jkostenbader

    Automate Adding Records To A Portal

    jkostenbader

      Consider a classic many-to-many relationship between a table called "Employees" and "Comments". Each employee could have many comments and a particular comment might apply to more than one employee. On the Comments layout, when I'm dealing with a comment that might have apply to a dozen or more employees, its very tedious to manually add these to the portal. I'd like a way to add a button that would reach into the related "employee" table and grab a subset of employees to add to this comment. The best method might be by department. So there would be a button that says "Add All Project Managers" (something like that).

       

      The specifics of scripting this are probably above my current level of training. If someone might have something similar they could show me I'm pretty good at following the logic. Assume the following primary keys

       

      ID_Employee

      ID_Comment

      Join_ID_EmployeeComment

       

      The portal in question is of course based on the join table.