Corrupted Portal ??
I was writing ID numbers in a many to many configuration using a portal. Movies and Actors are already in the system. I select actors from the Actors Table on the Movie Layout using a drop down with the Actor Name and the ActorID. The system works fine but in one of the applications I pasted the wrong field in the Portal and finished writing a new ActorID in the Actor Table instead of a new ActorID in the Role Table. I was forcing a new number in the auto enter serial field.
Since I discovered the error I replaced all records in the Actors and created a new portal. I entered numbers in the Role Table to create the proper relationships without using the portal. Now the Role Table field ActorID shows 1, 2 and 3 for different records but the Portal shows 1, 1, and 1 for the same field.(or 2, 2 and 2, ..)
It seems to me there is some corruption in the portal. If so, what is the best way to fix it?