"I want to be able to show all records in a portal rather than just related ones"
You can use the X operator instead of the default = operator in the portal's relationship to match all staff records and then they will all appear in your portal.
- Open Manage | Database | Relationships
- Double click the line linking the two table occurrence boxes that represent your layout and portal.
- Use the operator drop down to change = to X.
Thank Again Phil,
This will not affect the operations of any of my other functions from these tables will it.
It might if you have calculations defined in one of these tables that refers to fields in a related record in the other.
If that's the case, you should create a new table occurrence of the portal's table and set it up for your portal.