I have a contacts layout where I want to be able to be viewing one contact's record and move to their partner's record (if applicable) at the click of a button in the layout.
Basically I need to be matching the "Contact Partner ID Number" to the "Contact ID Number" (if there is one) but can't find how to do this effectively.
If I had a simple table (below), with 4 fields and 5 records... by clicking a button while viewing Tom's record, I'd be taken to Sally's (record 5); from Dick's I'd go to Jane's (record 4); Jane's would take me to Dick's (record 2) and from Sally's I'd go to Tom's (record 1). As Harry has no partner on the system then nothing would happen.
Hope someone can help.
|Record ID||Contact ID Number||Contact Name||Contact Partner ID Number|