ODBC SQL

[peterlacenne]

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)...