AnsweredAssumed Answered

Relationships, Join Tables, Portals and headaches!

Question asked by MeganMcFadden on Jun 24, 2013
Latest reply on Jun 25, 2013 by MeganMcFadden

Title

Relationships, Join Tables, Portals and headaches!

Post

     I am trying to create a layout that will have two portals. One portal will reference the contents/parts of the Product. The other portal will show the usage of the Product.

      

     In order to have the contents show on the layout I have created the following tables:

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
                    

Set Listings

               
                    

Set Assembly (join table)

               
                    

Set Parts

               
                    

                         Serial ID (auto serial number)------------

               
                    

                         Set ID (number field)

               
                    

                          

               
                    

                         Set Name

               
                    

                         Item Number----------------------------------<

               
                    

                         Item Number

                    

                         Description

               
                    

                         Home City

               
                    

                         Quantity (number field)

               
                    

                          

               
                    

                         Home Hospital Rep

               
                    

                          

               
                    

                          

               
                    

                         Ownership

               
                    

                          

               
                    

                          

               
                    

                         Manufacturer

               
                    

                          

               
                    

                          

               
                    

                         Status (active, retired)

               
                    

                          

               
                    

                          

               

      

     My relationships look like this:

      

File_Maker_Page.jpg

Outcomes