I have a portal in a table that is related to another table labeled employees. The employees table contains all pertinant information for that employee.

The portal shows the employees for a given apartment complex. The information is first name and last name and status. I want to be able to click an Icon within the portal and be taken to that employees information page. (The Related Table)

1. If that is possible how do I do it?

2. Can I make the portal show only employees that are "Active"

Any help is appreciated.

1. Use the script step GTRR (Go To Related Record), implemented by a portal button.

2. Add an active field to Apartment_complex (automatically set to 1 or yes or whatever you're using in Employee); link the two tables by both apartment_complex and active field. Then only active employees will show in the portal.