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

[Maxime]

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.