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