2 Replies Latest reply on Oct 20, 2012 1:21 PM by RickyFarr

    Still struggling to add record



      Still struggling to add record


           I have spent several days on this and have conceeded that I need help with it.....

           I have attached a screen shot - I will put a button under the ProceduresSelect drop down box. Once a selection has been made I need the button to 'push' the selected value into the ProcedureSelected box on the right - therefore populating that field.

           Can anyone walk me through this... its driving me mad!

           Thanks in advance


           p.s. I have spent the best part of 2 days going through forums and watching tutorials, but I have not seen this done yet - so if you know of a link please let me know.


        • 1. Re: Still struggling to add record

               What you describe does not add a record, it modifies data in a field.

               Why is the Procedures field many lines of text in height?

               Are you adding the selected text to the text already in that field? That can be done, but there are likely much better design options for what you are trying to do here.

               This script step can be the action for your button, but please keep in mind that this is implementing somthing that is likely much less than an optimum design for your database:

               Set Field [Visits::Procedures ; List (Visits::Procedures ; Visits::ProceduresSelect ) ]

               This appends the contents of ProceduresSelect to the end of the list of procedures already present in the field.

               But I think you need a related table of selected procedures and a portal to that related table instead of simply putting text in a large text field as is currently shown on your layout. I suggest looking up "portal" in FileMaker help and any training materials you might have as the next thing to research for your database project.

          • 2. Re: Still struggling to add record

                 Genius! Thank you PhilModJunk - it works!!  

                 Task almost complete! ;-)