>Cetin,
>
>I'll definately keep that in mind (another tip to store in longterm memory). I have a 2 part question for you. (1) If I do an SQL select statement, can I direct the data to a specific folder (e.g. from server to C\myFolder\Data). (2) I would like to run this procedure just after the load and init events occur, so the main form is ready to go on the screen once the wait window clears telling me that the data has been transferred.
>
>Thank you
>Perry
1) Yes you could direct it to another folder :
select ... into table ("c:\my private folder\data folder\mytable")
I intentionally wrote like this to also show that you could handle LFN containing spaces (surrounding with parentheses is my (good) habbit to refer name expressions also not needed in this example).
2) If you mean for this SQL you could do it whenever you want (SQL would open any necessary source file if not open already but for different data envi. uses it would be better to do it in init).
If you do this SQL for that combo no need to do it to a table. Just write your sql to rowsource and set rowsourcetype to SQL.
select...into cursor tcMyCmbCursor
Cetin