1 2 Previous Next 20 Replies Latest reply on Apr 12, 2012 6:30 AM by RyanCourville

    Dynamic List

    RyanCourville

      Title

      Dynamic List

      Post

      Hey

       

      I am working on a dynamic pop up menu.

       

      I have a company, item, and how to make.

       

      I want to have the company selected first, which effects what items are made for that company, then the how to make it comes up.

       

      example

      Joes > burger > put on grill, add cheese, toast buns etc.

       

      Attached is the relationship I have on the tables.

       

      I have only 2 tables with 2 duplicates of the tables.

       

      I have the workorder table which will be where the company is selected and where the items will come up and then the how to will show.

       

      I have the tools table where the customer is, tool, and procedure to make it.

       

      I got it to show only the customers referencing the tools, but the tools dont come up or the how to.

      relationship.JPG

        • 1. Re: Dynamic List
          philmodjunk

          Is this what you want using the actual field names you have in your database?

          You select Customer ID to see a list of tool records.

          You select a tool and see data for both Tool Items and Tool Procedures Appear?

          Does your layout refer to Work Orders in Layout setup | "Show records from"?

          If so, you need this relationship:

          Work_Orders::_Fk_customer_ID = ToolsByCust::_pk_Customer_ID

          ToolsByCust is a new occurrence of tools, not your existing tools occurrence--which needs to be kept as you have it.

          Your value list should list _PK_Tool_ID from ToolsByCust as field 1 and a name field from ToolsByCust as field 2.

          Specify the Include only related values starting from Work Orders option.

          Now add the Tools::Tool Procedure field to your layout.

          When you select a customer in _fk_Customer_ID, the value list of tools will be limited to that customer. When you select a tool, the ::Tool Procedure field will display that data from the same related record.

          • 2. Re: Dynamic List
            RyanCourville

            I think this will work I have have to get it a shot!

             

            Thanks,

             

            Ryan

            • 3. Re: Dynamic List
              RyanCourville

              I gave it a shot and still didnt work maybe I did something wrong.

               

              I took a screen shot of everything and a description of what I am trying to do.

               

              On the workorder layout (top left) it has a pop up menu where the customers are, it pulls this info from the tool layout bottom right hand corner.

              I have the relationship correct (I think) and and the value list to the top left.

               

              Help

               

              lol

               

              Thanks,

               

              Ryan

              • 4. Re: Dynamic List
                philmodjunk

                It all looks correctly set up.

                Is the _FK_TOOL_ID field the field that is set up with this conditional value list as shown in your screen shot?

                Where/how does this fail to work for you?

                • 5. Re: Dynamic List
                  RyanCourville

                  Yes _FK_Tool_ID is where the tools show up.

                   

                  When I click on _FK_TOOL_ID on the workorders list it says <no values defined>.

                  • 6. Re: Dynamic List
                    philmodjunk

                    Had you first selected a customer in the Work_Orders::_FK_Customer_ID field?

                    Then you need to examine the values of the match fields used in these relationships.

                    When you go to a layout based on tools, do you see values in the _PK_Tool_ID field?

                    Are there values in the two _FK_Customer_ID fields (Check layouts for both Work Orders and Tools)?

                    If there are values in these fields, do the values match?

                    • 7. Re: Dynamic List
                      RyanCourville

                      Hey

                       

                      I got it to kinda work but not really lol

                       

                      When I select company and then go to pick item it shows only the first item for that company but not the other items.

                       

                      Example

                      Customer: Joes

                      item_ID 1 - burger

                      item_ID 2 - fries

                      item_ID 3 - shake

                       

                      when you select "Joes" and then the Item it will only show Burger on the list. Not fries and shake as well.

                      Its doing that for all the companies i have, each have about 4 or 5 items right now and they only show

                      the first record.

                      • 8. Re: Dynamic List
                        philmodjunk

                        In your example, the second field lists text. Is it by any chance a calculation field? If so, make sure that "text" is the specified return type for the calculation. Otherwise, if you are sorting on the second field in the value list setup, you'll only see one entry.

                        • 9. Re: Dynamic List
                          RyanCourville

                          Hey

                           

                          OK so I got the it to work half way.

                           

                          I got it so when you select Customer it filters the tools by customer.

                          But now the procedure wont come up.

                           

                          I have tool procedure as an edit box to just pull in info from the tools.

                           

                          But I changed it to a pop up menu and then set it to only show related info from customer table and it has the procedures of all the tools only related by the customer.

                           

                          But I need it to show automatically, not by a pop up or anything.

                           

                          Any suggestions.

                           

                          Thanks,

                           

                          Ryan

                          • 10. Re: Dynamic List
                            RyanCourville

                            Here is the relationship.

                             

                            The tool procedure realtionship to it self is just trouble shooting.

                             

                            Customers are where the customer names are, then at tools you select tool as well as customer and set the procedure. Then the second occurance of the tools is where it is pulled into Workorders, and the combined info is shown. (Customers, tools, procedure)

                            • 11. Re: Dynamic List
                              philmodjunk

                              Did you put the Tool Procedure field from Tools on your work order layout?

                              • 12. Re: Dynamic List
                                RyanCourville

                                Hey

                                 

                                I took away the relationship between the tool tables.

                                 

                                I related the Workorders, tool procedure field to show data from toolsbycust tool procedures.

                                It shows only the first value even when I change the tool.

                                 

                                EX:

                                 

                                record 1

                                Customer: Joes

                                Tool: Burger

                                Procedure: abc

                                 

                                record 2

                                Joes

                                chicken

                                def

                                 

                                record 3

                                joes

                                steak

                                ghi

                                 

                                I select

                                 

                                Joes > Steak > and it shows abc

                                Joes > Chicken > and it shows abc

                                 

                                not the procedures I set

                                 

                                Any suggestions

                                 

                                Thanks,

                                 

                                Ryan

                                • 13. Re: Dynamic List
                                  RyanCourville

                                  New relationship.

                                   

                                  thanks,

                                   

                                  Ryan

                                  • 14. Re: Dynamic List
                                    philmodjunk

                                    Put the relationship back. You need it to display the related record's tool procedure.

                                    1 2 Previous Next