1 Reply Latest reply on Jan 14, 2010 11:41 AM by mrvodka

    SQL query help

    TR

      Title

      SQL query help

      Post

      I am new to FM and using version 10.0v3.  How do I do the following:

       

      I have a seperate SQL 2005 application that has live patient data in it.  I need to do a read only lookup on that SQL DB/table based on last name that will list all the accounts with the same last name at which I can choose that patient.

       

      This patient data will then autofill into a FM form that has about 40 questions to answer and store in the FM DB.

       

      Thanks for your help

      TR

        • 1. Re: SQL query help
          mrvodka
             You can script this so that it pops open a new window with a layout based on the table occurrence of the ESS shadow table. You can perform a find there and then when it return a list of the people that you found, via an action on a button for that record, it could close the window and then populate the data into your initial record.