connect to SQL DB

[mcotton]

Hi everyone! Here's my problem: I connect from FileMaker to an SQL database to retreive data and display it in FileMaker layout. I do an import data on the odbc connection. Everything works well, but when I need to retrieve only some data (where clause), FileMaker only display table from the odbc connection. I need a select * from odbcTable where odbcTable.field1=fileMakerLayout.field (or =variable)...

Thanks!

[JirkaJindra]

I have same problem. Everyone help my? Thanks