Read Data from SQL Server

[Joe Grosskopf]

I have a list of all my customers in a SQL 2000 Database. I am creating a Filemaker Database for order information. Rather than re-type all Customer info, I'd like to simply add acustomer number field to Filemaker and have it lookup the name, address, etc. in the SQL Database based on that customer number field (Select SQL.name from SQL where Filamaker.Cust_No = SQL.Cust_No). Can this be done? If not, can anyone suggest a way to make this work without double entry of information? Thanks