Portal displaying wrong records

[titanium]

Hello,

I have a DB setup and running and have just started to use it live after much testing and tweaking. I have found a problem, that im not sure ware it come from so not sure how to look at fixing it. My Portal is displaying records that it should not.

I have customers, each customer has systems and each system has inspections. The portal shows the inspections done in the past for the system selected for that customer.

For some reason (and seems to be random...i cant see logic in it anyway) when in the customer record the portal is showing inspections done for other customers systems.

Here are two screen shots which show the portal setup and the relationship that gets me to their... Is this an issue with the portal? If this has been discussed in another thread PLEASE link me to it, i cant find for the life of me! Thanks for the kick in the right direction.

I have checked that all IDs are unique... each customer and system and inspection ID are all unique, so that cant be it...can it?

[titanium]

So the problem has been resolved. I wanted to post the resolution here in case anyone else may find it helpful. (im still learning but want to share with the community if i can)

Turns out to be pretty simple... The SS_ID that is used to define the relationship (see images in the first post) was set as a NUMBER field, however, my database has unique IDS which are strings with both numbers and letters. So... all that was required was to change the field type to TEXT and the portals instantly started to behave as they should.

I hope that some day this helps someone solve a problem they encounter.

Cheers.