Is this data being retrieved after the user enters the Customer ID?
If so then you can set up th econnection to have a delayed open (so that you can control when the connection to the DB is established). There is a checkbox on the 2nd screen of the data connection wizard.
Now you can create the SQL statement and set a property of the DtaaConnection (programmatically) and open the data connection. If you post your email address I will send you a sample. You will not have my DB but you will get the idea.