AnsweredAssumed Answered

Match Records from two different tables.

Question asked by KylePrince on Dec 1, 2013
Latest reply on Dec 1, 2013 by philmodjunk

Title

Match Records from two different tables.

Post

     I'm unsure exactly how to phrase what I want to do briefly so I'll apologize if the title is vague. Essentially what I'm trying to do is  this. I have three tables as such

     Table 1                        Table 2                      Table 3

     Some fields                 Some Fields            Some Fields

     CurrentMonth             Month                       Description

     Category Name          Category Name      Category Name

                                           Description

      

     I want to create a layout (ideally based off table 1) that shows me the matching records from table 2 (for both month and category) but only if those records have a description matching one of the descriptions in table 3. Currently I have the database related as follows:  

      

      

     Table 1                            Table 2                             Table 3

     Some fields                      Some Fields                    Some Fields

     CurrentMonth    --- = ---  Month                       

     Category Name --- = --- Category Name --- = --- Category Name

                                                Description         --- = --- Description

      

     This works partially...A layout based table 1 will show me all the records from table two with matching months and category names (in a portal) and a layout based on table 3 will show me all the records from table two with matching category names and descriptions but I haven't yet been able to get it to worth with both - surely there should be a way to do this kind of specific find? I also realize that in my particular case I might be able to get away with moving currentMonth into Table 2 and using a self-join relationship (what I'm about to try next) but for my own reference I want to know if there is a way to do what I'm trying to do. Obviously you could enter find mode - but the point of this is to have a layout that always has this information readily available - rather than having to perform a find or run a script every time you want it.

     Thanks for any guidance you can give.

      

Outcomes