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



      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

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

          Please show your graph.

          • 2. Re: Portal

            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

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

              • 4. Re: Portal

                Brevity is...?

                • 5. Re: Portal

                  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  



                  the portal related records is from marks table.


                  hope this is clear enough

                  • 6. Re: Portal

                    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

                      haider2016 wrote:

                      hope this is clear enough

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

                      • 8. Re: Portal

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

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

                        • 9. Re: Portal

                          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

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

                            But - back to haider2016 - yes, graph please.

                            • 11. Re: Portal

                              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

                                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.