Portal (Self Join) Showing Duplicate Records
I remember running into this problem a few years back but for the life of me I can't remember the solution. I do recall that it was simple but I've had many gray cells retire on me since then :)
I've got a self join. The key field is 'Job_Id'. There are 3 records in the table with the same Job Id. The portal show's correctly that there are 3 records but all of the portal rows show the same info. (the info contained in the first record used for the join). I can scroll through the other two records and the info in the portal changes to match the particular record but still the same data show's up in all 3 rows. I thought it may help if I put the join data in a global field but it was no help.