12 Replies Latest reply on Jun 15, 2012 2:19 PM by krobin8

    Portal only shows one record?

    krobin8

      I have three related tables:

       

      1) Schools

      2) Students (must be assigned a school)

      3) Orders - the order is related to the student and the school, so I can see total orders by school, as wells as total order by student.

       

      When I enter the order screen I have a portal that I want to filter all of the students and contact information by whatever school I choose. However, I only get the first student from that school in the portal, not any of the other students?

       

      I know its a rookie error I am making but after 7 hours of trying to fix it I have had no luck.

       

      Thanks!

        • 1. Re: Portal only shows one record?
          Stephen Huston

          I would assume your relationships look like this:

          • Schools have many students but students have one school
          • Students have many order, but orders have one student

          IN that case, each Order record will have only one related student that it can show. There is nothing to filter when viewing from the Order-based layout, no matter what the portal is intended to show.

           

          You might want to perform Finds when on the order screen rather than thinking in terms of filters, and view the result in list view.

          1 of 1 people found this helpful
          • 2. Re: Portal only shows one record?
            krobin8

            You are correct. When creating an order, my first step is to select a school, then select a student based on that filter. When I use a conditional value list I can get all of the students to appear. When I choose the student (any student) I want the contact information from the student file to transfer into the order (invoice). However, regardless of which student I choose I again only get the first students information in the other fields (address, ph number, email, etc.).

             

            On doing more research I saw someone suggest using a portal with a button in it to choose that student, but that does not appear to work either.

             

            Thanks so much for your help.

            • 3. Re: Portal only shows one record?
              comment

              krobin8 wrote:

               

              When I choose the student (any student) I want the contact information from the student file to transfer into the order (invoice). However, regardless of which student I choose I again only get the first students information in the other fields (address, ph number, email, etc.).

              You need another relationship between Orders and a second occurrence of Students, based on matching the chosen SchoolID. Use this relationship to filter the students value list:.

               

              Schools  -< Students -< Orders >- Students 2

               

               

               

              Message was edited by: Michael Horak

              • 4. Re: Portal only shows one record?
                Stephen Huston

                You did state that the portal was on a layout based on Orders. There will only be one related student for any record in the Orders base table.

                 

                If you are trying to use a portal filter to select the school and then assign the student, you really shouldn't be using a portal at all, just a filtered value list with fields in the order record. Filter the value list itself and don't use a portal. The portal arrangement you set up only makes sense if you were trying to create student records from an Order.

                 

                You will need another set of TOs in your relatinoship graph to create the relationship between School and Students to filter the value list for students by school.

                • Order [x] School –> Students

                Show all schools to pick from in the Order record, then filter the list of students by the school chosen. No portals involved.

                • 5. Re: Portal only shows one record?
                  krobin8

                  Please take a look at this and tell me what I am missing. Where would I create another occurence of schools?

                   

                  fmp.jpg

                  • 6. Re: Portal only shows one record?
                    comment

                    I have edited my post while you were replying - hope it answers your concern. Note that the rightmost relationship is:

                     

                    Orders::SchoolID = Students 2::SchoolID

                     

                     

                    It's not the only way to arrange the relationship graph but I believe it's the most efficient one in the circumstances.

                    • 7. Re: Portal only shows one record?
                      krobin8

                      I still don't get it. Whenever I choose the school from the value list, it takes the first student assigned to that school and fills in their information in all of the fields, then when I choose the student from the list, nothing changes.

                       

                       

                      • 8. Re: Portal only shows one record?
                        Stephen Huston

                        Where does it fill in the student info? Are you using lookups instead of value lists to populate the Order record?

                        • 9. Re: Portal only shows one record?
                          krobin8

                          On the order layout there is a value list drop down "Schools2:_kf_student_id". The value list shows both the student id and seconf field Student Name. This list is filtering properly by my choice of school in the value list above it.

                           

                          After choosing that I want other fields on the order form to fill in:

                           

                          "Schools2: Student Name"

                          "Schools2: Student Address"

                          "Schools2: Student Email"

                          "Schools2: Student Phone"

                           

                          etc. etc.

                           

                          However, regardless of which student I choose, the other fields just stay on the first student from that school?

                          • 10. Re: Portal only shows one record?
                            comment

                            See if this works for you:

                             

                            BTW, you only need to lookup data that's bound to change - otherwise you can simply place the related fields on the layout (see the Name field vs. LookupSource).

                            • 11. Re: Portal only shows one record?
                              comment

                              Here's a slightly more orthodox version:

                              • 12. Re: Portal only shows one record?
                                krobin8

                                Thank you, Thank You, Thank You.

                                 

                                You have created in 5 minutes something that has perplexed me for two days.

                                 

                                I hope I can help out a fellow newb in the future!

                                 

                                Thanks also to Stephen!