You have the right idea A form with a table where you can select multiple employees and a second table where you can select multiple roles.
On button click call guide 1 that walks the employee table for selected rows. In guide 1 an Active Link calls guide 2 that walks the selected roles. In guide 2 an Active Link that does the push of employee.ID & role.ID to table 3 Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of sapana motwani Sent: Wednesday, May 09, 2012 8:37 AM To: [email protected] Subject: Re: Nested Active Links ** Any help would be greatly appreciated. Regards, Sapna On Fri, May 4, 2012 at 9:55 PM, Sapna Motwani <[email protected]<mailto:[email protected]>> wrote: Hi, I have a situation where I have three tables, Table 1 Employee Table with two columns Employee Name name and Employee ID (Primary Key, GUID) (Employee Master Form) Table 2 Available Roles with two columns Available Roles and Role ID (Role Master Form) Table 3 Selected Roles with two columns Selected Roles and Selected Role ID (Emp-Role Relationship Form) (Emp ID and Role ID integration) Now, I have to implement a workflow which can move multiple Available Roles to Selected Roles table for multiple Employees (Selected Rows of Employee Master) i.e. On click of "Assign Role Button" multiple selected records from Available Roles table (Role Master Form) should get pushed to Selected Roles table (Emp-Role Relationship Form) and roles should get assigned to selected Employees. (Employee Master Form). I have created a Active link guide which runs for selected rows of Available table and push the selected roles to Selected Role table (Emp-Role relationship form) for one employee at a time. Please help/assist to do nesting of active links guides so that multiple roles can be assigned to multiple employees in one go. Any help would be highly appreciated. Thanks in anticipation. Regards, Sapna _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
