AnsweredAssumed Answered

SQL query help

Question asked by TR on Jan 13, 2010
Latest reply on Jan 14, 2010 by mrvodka


SQL query help


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