1 Reply Latest reply on Nov 3, 2009 8:17 AM by TSGal

    Automatically entering information into ODBC fields



      Automatically entering information into ODBC fields


      1. The version of FileMaker Pro you are using. Filemaker Pro 10 Advanced


      2. The operating system and version you are using.Mac OS 10.5.8


      3. Database Description


      I have set up a relational database for my clients that connects individual contacts to one company address. It is set up as follows:

      Table 1 = Client Companies - contains company logo, address, and main contact phone number

      Table 2 = Individual Employee Names - contains email addresses, direct phone numbers, etc. In the past it has pulled the address for the individuals based on whether or not they have the same company name.


      4. Give examples of what you are trying to accomplish, but can't.  



      Since this database has been set up we have added a website with all of the individual website profiles. I now need to have it take the updated address info from table 1 and run a script to have it automatically enter that into the fields that I have for each individual in Table 2. So for example I update Johnson Companies street address in table 1. I want it to automatically go to each of the Johnson Company Employees records and enter in the new address information. 


      The only catch is that it can't be a calculation. It has to be some sort of script or look up because the field I am entering the information into is a website field that is linked via the ODBC Driver. 


      I can get the script to run on one record but I can't get it to automatically cycle through all of them. 

      5.  level of experience with FileMaker and/or other database designs.  I am a self taught filemaker nerd so I definitely am not a database guru so I appreciate any help that I can get!



      6. Please indicate whether your database file is being shared over a network, or being published to the web via either Instant Web Publishing (IWP) or Custom Web Publishing (CWP). This database is on Filemaker server and is linked to the web via the ODBC driver

        • 1. Re: Automatically entering information into ODBC fields



          Thank you for your post.


          To cycle through a set of found records, use the Loop construct.  Here is a quick example:


          Go to Record/Request/Page [ First ]


             Go to Record/Request/Page [ Next ; Exit after last ]

          End Loop




          This script goes to the first record in the current found set and then enters a look.  Then, go to the next record and loop back.  When the last record has been processed, the script exits the loop.  Obviously, this is a very simplistic case, as you will probably have many commands between "Loop" and "Go to Record [Next] ".


          This should give you a good starting point.  Let me know if you need clarification for any of the above steps.



          FileMaker, Inc.