So if you defined a calculation field as: GetAsNumber ( ModelNumber ), your records for
will all show the value 9300. If you define a self join linking records by this calculation field, Any one of these records would list all three in the portal. If you don't want to list M09300R in the portal when your current record on the layout is for M09300R, you can use this relationship:
YourTable::ModelNumber ≠ YourTable|SameModelID::ModelNumber AND
YourTable::cModelID = YourTable|SameModleID::cModelID
Where cModelID is the above mentioned calculation field. YourTable and YourTable|SameModelID are two Tutorial: What are Table Occurrences? for the same table.
Im pretty positive that its a many to many relationship, apologies if I am not understanding and/or I wasnt clear.
Each Model Number is Unique
There is no M00900 as each Model Number has an attached Suffix that makes it unqiue (a color identifier)
Would be all the models associated with M09300
So the portal is wanted to show this.
Current ModelNo (Displayed Record) M09300Y
[ M09300R ]
[ M09300BL ]
[ M09300GR ]
I already have fields that are Specified for Model Prefix/Number/Suffix
So for the record M09300Y
If i were to display the 3 fields:
Hopefully this image gives a better idea
This does not change what I have described here.