4 Replies Latest reply on Jan 25, 2009 6:05 PM by miw

    List entry input



      List entry input


      I have a two table relational DB.  In Table 2, I have an entry input (list) based on a list of names in a field from Table 1 in order to establish the linkage.  That part is simple; but I also want to include at the bottom of the list another option which would allow the user to go to Table 1 if the desired input is not yet listed in Table 1.  So I was thinking of adding at the the bottom of the defined list from Table 1:  "Go to Table 1 if not listed" and then execute a script going to Table 1 if that was the selection.  How can I append the Table 1 list to also include such notation?  (I do not want to create a record in Table 1 with this input nor do I want to let the field be added to Table 1 via the Table 2 layout screen.)

        • 1. Re: List entry input



          Thank you for your post.


          I understand the script to switch from table 2 to table 1 (Go to Layout script step).  However, I'm a little confused where you say "How can I append the Table 1 list to also include such notation?".  Does that mean, you want a Table 2 list to appear on the Table 1 layout?  Or, did you want some information from Table 2 to appear in a separate area?  Or, did you just want a button to switch back to Table 2?  Can you be a little more specific?



          FileMaker, Inc. 

          • 2. Re: List entry input

            Let's say my Table 1 linked field has 5 records in it, such as A1product, B2product, C1product, C2product and Zproduct.  In my normal layout screeen for Table 2, I can easily get a list input that will bring up those five records to establish the proper link via making the input filed a list field linked to Table 1.  However, I want to go one step further: what I would like to do is further add to the list "Go to Table 1" and thus show the list like this:







            Go to Table 1


            The purpose would be that if I was in Table 2 and wanted to make a link whereas the field would be M4product, since that is not already in Table 1 via the list and records at Table 1, I could select the "Go to Table 1" option in the list and run a script that will take me to Table 1, make a new entry for M4product, complete other related data thereto and then go back to my Table 2 screen which would then have the M4product added to the list.


            Does that make sense?

            • 3. Re: List entry input



              Thanks for the additional information.


              When you link a value list to related table, you only get those choices that exist in the related file.  If you want, you can include a dummy record in Table 1 with the value "Go to Table 1".  Otherwise, you will have to create your own custom value list and include all the values from Table 1.  Unfortunately, any time you add records to Table 1, you will have to update the custom value list.


              Assuming you use what you have now, and you add a "Go to Table 1" dummy record, you then want to switch to Table 1 when you select this option.  This can be done through a script trigger, assuming you have FileMaker Pro 10.


              First, create a new script "Go to Table 1".  The script steps would be:


              If [ Table 2::<list field> = "Go to Table 1" ]

                 Go to Layout [ <Layout with Table 1 data> ]

              End If


              That is, if you execute this script, and the value in the field is "Go to Table 1", then you switch to the layout that displays the Table 1 data.


              Next, pull down the View menu and select "Layout Mode".  Click on the drop-down field, pull down the Format menu and select "Set Script Triggers".  Put a checkmark in "OnObjectExit" and specify the script that we just created above.  Click OK twice to return to Layout Mode.  Pull down the View menu and select "Browse Mode".


              If you click on this field and select any value other than "Go to Table 1", you'll stay in the same layout.  When you select "Go to Table 1", you will automatically be sent to the layout where Table 1 data is displayed.


              Please let me know if you need clarification for any of the above steps.



              FileMaker, Inc. 

              • 4. Re: List entry input

                I really wanted to avoid creating a dummy file for the ability to select going to the other table.  I fixed the problem by making a dialog box script - if the to be linked field is blank or not a match to Table 1, a dialog box pops up to warn the user and allows going back to edit mode, reverting the record back or go to the Table 1 window.


                Thanks, for your suggestion - the clues you gave helped me figure this out...