3 Replies Latest reply on Jun 17, 2014 8:39 AM by philmodjunk

    Portal to Show all Records "Where" clause

    AnthonyPaliseno

      Title

      Portal to Show all Records "Where" clause

      Post


           Basically I have a crap ton of Model Numbers

           For example

           M09300Y
           M09300R
           M09300CL

           M02400R
           M02400BL


           M being the Prefix
            

           09300 being the number


           Y/R/CL/BL all being Suffixs

           When im displaying a record in Form View, for example M09300R

           I want a portal to show the related records
           M09300Y
           M09300CL

           Basically the Prefix and ModelNumber dont change, it's the Suffix that is the unqiue part

            

            

        • 1. Re: Portal to Show all Records "Where" clause
          philmodjunk

               So if you defined a calculation field as: GetAsNumber ( ModelNumber ), your records for

               M09300R
               M09300Y
               M09300CL

               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.

          • 2. Re: Portal to Show all Records "Where" clause
            AnthonyPaliseno

                 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)

                 M09300Y

                 Related Models

                 Would be all the models associated with M09300

                 M09300Y/R/BL/GR

                 etc

                  

                 So the portal is wanted to show this.

                 Current ModelNo (Displayed Record) M09300Y

                 Portal
                 [ 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:

                 M
                 09300
                 Y

                 Hopefully this image gives a better idea

                  

            • 3. Re: Portal to Show all Records "Where" clause
              philmodjunk

                   This does not change what I have described here.