Hi - 

I have Form A that contains employee names, and Form B that contains notes associated with the employee, with a lookup to Employee_Name in Form A.

When a note in Form B is created or edited, the script below writes a link to a rich text field in Form A that when clicked in a report opens to a pop-up of all the notes associated with the particular employee.

It is working fine by creating a URL where ?Employee_Name=lookup.Employee_Name.last_name, but I'd like to include first_name in the filter as well, as some employees have the same last name.

I have tried just using lookup.Employee_Name but no link is created, and using the record ID has not worked as well, as the report for Form B seems to want the text value of Employee Name and not the numerical value.  Just appending the first name as a second criteria as described here has not worked, probably because the first and last names are connected to the same Employee_Name field.

Any thoughts on how to add the first name as a second search criteria?  Thanks,

2. lookup = Form_A [ID == input.Employee_Name];
   
3. lookup.rich_text_field=("<a href='#View:Notes_Report?Employee_Name=" + lookup.Employee_Name.last_name + "&zc_LoadIn=dialog'>" + input.Note_Description + "</a>";
   
4. openUrl("#Script:page.parent.refresh","same window");