This is done with a self-relationship; which is almost the same as a plain relationship, but is between two table occurrences (TO) of the same base table. In your case you would have 2 TOs of the Services table, the existing one and another. Duplicate the main one to get it; name it appropriately; I like to use the term "_self" then the field. The last part of the TO name would look like this:
The relationship is, as you can see, between the ClientID in Services, effectively letting you put a portal in the main Services table's layout to show the multiple services records for that client (including the one you're on).
I would actually add one more line to the relationship. Assuming you have a unique auto-enter serial ID in Services,* it would be:
ServiceID ≠ ServiceID (that's "does not equal)
This would remove the current Service record from the portal, just show the others. I'd rename the relationship to:
You may want both relationships, if you need the full self-relationship for other things.
Many thanks, got it.
Didnt realise to add another occurence to link to.
and yes i can use service_id to stop the current record being listed.