Importing data from an ODBC data source with a dinamicaly generated query??

Hi,

I'm trying to import data from an ODBC data source (Oracle8) to my FileMaker Pro database. The problem, is that my query in the query builder need to be based on a field in my FMP db and I want to do a script with all that so that I can do it automaticaly. It seem that I can't make a reference to the field in the query builder of FMP so I have to always change the value of the WHERE statement manualy. Here's an example of want I do:

SELECT fisrt_name, last_name FROM my_table WHERE id = 12345;

but what I want is:

SELECT fisrt_name, last_name FROM my_table WHERE id = my_filemaker_bd.id;

where "my_filemaker_bd.id" is a field in FileMaker that always change and the query is based on that field.

Any idea how I can do that?

Thanks.

Maxime Paquette

Scripto Centris. Inc.