6 Replies Latest reply on Apr 28, 2010 3:56 PM by yson

    data- multiple search with same condition

    yson

      Title

      data- multiple search with same condition

      Post

      Hi,

       

      I'm new with FM10. I have some question about record search.

       

      E.g  :  I have 2 tables - one table 'A' contains grouping ID to  the records.  The other table 'B' has records

                 with grouping ID information from  table 'A' respectively. How to find all record which has a  same

                  grouping ID and  display all of them at  portal page ?

       

      yS.

        • 1. Re: data- multiple search with same condition
          philmodjunk

          I'm afraid I can't follow that description. Can you post a more detailed example of what you mean with actual values?

          • 2. Re: data- multiple search with same condition
            yson

            HI,

             

            Thank you for your interesting. My examples are following ;

             

            Table 'A'

             

            group ID                Description

            -----------------------------------------

              pen                         pen

            book                         book

             

             

             

            Table 'B'

             

            item #          group ID

            ---------------------------------

             10                    pen

             14                    book

              15                   book

              17                   pen

              19                   pen

             

             

            -> How  to display all 3 pen group on the portal page ?'  I only can see 'item # 10  - pen ' on the portal page..

             

            sY.

             

             

            • 3. Re: data- multiple search with same condition
              philmodjunk

              Is this the realtionship linking the two tables?

               

              TableA::Group ID = TableB::Group ID

               

              Are the Group ID fields in both tables text fields? (Number fields can contain text and this will look correct but won't match values correctly.)

               

              If so, then a portal to Table B on a Table A based layout should list just the Pen records for the first record in table A and just the Book records on the second record of Table A.

              • 4. Re: data- multiple search with same condition
                yson

                Hi,

                 

                Are there any option to be set  to the portal with that relation?  I still do not get right result.

                Only first one record' of 3 records is showing. Or do I need to use script for this job?  If so, that's the bigger problem for me.

                 

                However, thank you for your help

                 

                sY.

                • 5. Re: data- multiple search with same condition
                  philmodjunk

                  No scripts should be needed. You do need it to be set to display more than one portal row, but since multiple rows are the default setting, I doubt that's the problem.

                   

                  You could post a copy of your file to a sharing site and then reply back here with the link if you want someone to take a look at it. Sometimes there's a small detail to the file that you're just not seeing and another person's fresh perspective might spot it.

                  • 6. Re: data- multiple search with same condition
                    yson

                    Hi,

                     

                    Thank you again.  I will do  that.

                     

                    Regards,

                     

                    sY.