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

    Dynamic List



      Dynamic List




      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.



      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.


        • 1. Re: Dynamic List

          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

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





            • 3. Re: Dynamic List

              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.









              • 4. Re: Dynamic List

                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

                  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

                    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



                      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.



                      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

                        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



                          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.





                          • 10. Re: Dynamic List

                            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

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

                              • 12. Re: Dynamic List



                                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.




                                record 1

                                Customer: Joes

                                Tool: Burger

                                Procedure: abc


                                record 2





                                record 3





                                I select


                                Joes > Steak > and it shows abc

                                Joes > Chicken > and it shows abc


                                not the procedures I set


                                Any suggestions





                                • 13. Re: Dynamic List

                                  New relationship.





                                  • 14. Re: Dynamic List

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

                                    1 2 Previous Next