Relating Records in same Table
I want to be able to relate records in the same table together. I want to be able to link them together by giving the JobID of both records.
What the portal should show then is the related records to that job. So for example If I make a record in RelatedJobs table and give it JobID's from 1 & 3 JobNumber MP000001 should show MP000003 like it does and MP000003 should show MP000001 but it doesn't.
When I click on a JobNumber in the portal I have it set to go to related record but it doesn't.