12 Replies Latest reply on Jun 10, 2017 4:11 AM by siplus

    Portal

    haider2016

      Hi there,

       

      I have two tables, departments and marks. The department table has information for more than one department. The mark table holds all marks for all subjects in all departments. The department layout has a pop-menu shows all subjects in that department. when I select a subject to see all student marks in that subject in another layout which has a portal based on marks table. The problem is that the portal always shows the first subject marks.

       

      any help please would be very appreciated

       

       

      Many thanks in advance.

        • 1. Re: Portal
          BruceRobertson

          How can there be student marks if there are no students?

          Please show your graph.

          • 2. Re: Portal
            erolst

            Department, subject, student, mark ... I take it this is an educational solution?

             

            If you look at the nouns above and compare that with

            haider2016 wrote:

            I have two tables, departments and marks.

            it seems to me that you need at least three, or four additional tables:

             

            haider2016 wrote:

            The mark table holds all marks for all subjects in all departments.

            but Marks are given to Students in Departments who study subjects, so I'd expect

             

                                                 Student                              Mark

                                                       |.                                      |

                                                      ^.                                     ^

            Department --< DepartmentStudent --< DepartmenStudentSubject >-- Subject

             

            As to the original problem, we'd have to see your tables and fields, the relationships, which relationship is used for the portal, and why selecting a student (based on what list?) would filter that portal ... the works!

            • 3. Re: Portal
              erolst

              Bruce, how come you're so laconic and I'm so verbose?

              • 4. Re: Portal
                BruceRobertson

                Brevity is...?

                • 5. Re: Portal
                  haider2016

                  Thank you for your reply, you and Bruce are right, I should explain more. In fact, I have four main tables. These are: department, student, marks and subjects.

                   

                  student ----< marks     

                  student ----<subjects  

                  department----<student

                   

                  the portal related records is from marks table.

                   

                  hope this is clear enough

                  • 6. Re: Portal
                    erolst

                    BruceRobertson wrote:

                    Brevity is...?

                    ... golden? The mother of invention? Twice shy? The spice of life? The square root of all evil?

                     

                    Heck, I don't know ...

                    • 7. Re: Portal
                      erolst

                      haider2016 wrote:

                      hope this is clear enough

                      A screenshot of your Relationship Graph would make matters even clearer.

                      • 8. Re: Portal
                        BruceRobertson

                        You left out  ... "the soul of wit"

                        Is your question about lack of character or lack of characters? 

                        • 9. Re: Portal
                          erolst

                          BruceRobertson wrote:

                          You left out ... "the soul of wit"

                          Must be because I was missing it.

                           

                          Anyway, correlation is not causation, so it wasn't a question of character. Think nothing of it.

                           

                          Thank <insert favourite world explanation model here> it's Friday and we can be silly.

                          • 10. Re: Portal
                            BruceRobertson

                            Maybe we need a T[ X ]IF custom function.

                            But - back to haider2016 - yes, graph please.

                            • 11. Re: Portal
                              fmpdude

                              As you can see by the basic questions being asked, we need to see your RG.

                               

                              Also, any screenshots of your layouts would also, possibly, be helpful.

                              • 12. Re: Portal
                                siplus

                                TBH I love Bruce being calibrated around the "mildly annoyed" value to start with.

                                Any failed input from the OP will pack his answers into a higher value of sarcasm and I can't get enough of it.