1 Reply Latest reply on Feb 6, 2013 8:51 AM by philmodjunk

    Relational databases and search results

    JessicaCol

      Title

      Relational databases and search results

      Post

           I have in my database two tables. The first (main) table is Projects. The second is Members.

           Each Project has two or three members, and key information about these members shows on the Projects form using a portal with several rows. I believe this is a one-to-many relationship?

           The two tables are currently linked by the field 'Project Name' as this is unique to each project.

           Having performed a 'find' search for male members on the Members table  I would then like to be able to view the results in a list form or layout showing the members name and the project they belong to.

           However, the layouts I have managed to create will only show the first member for each project (regardless of whether they are male or not).

           How can I create a layout that shows all relevant members, especially when there is more than one per project?

           Thanks in advance!

        • 1. Re: Relational databases and search results
          philmodjunk
               

                    I believe this is a one-to-many relationship?

               yes

               

                    the layouts I have managed to create will only show the first member for each project

               Sounds like your layout is based on Projects instead of Members. Perform your search on a layout based on Members. Include the fields you need from projects on this layout to show the project to which each member is linked.