(cases are moved to this table and deleted from Active Cases when marked as closed).
This is not necessary in most situations and complicates your solution. What problem are you solving by doing this?
The relationship between these tables is based on the field EmployeeName.
This sets you up for possibly serious problems with your database should you ever get two employees with the same name, if an employee changes their name, or an employee name is accidentally entered with incorrect spelling and related records are created before the error is identified and corrected. Using an employee number avoids those issues.
I would guess that your portal is empty because you are on a layout for Active cases and have not yet committed the new record with an employee name. But that's a guess as you don't describe the layout on which you are placing your portal nor whether you link Case Storage to Active Cases or to Employees.
Thank you for your reply! It was enough information to get me thinking in the right direction, and I am pleased to say I got it going. Thank you!!