display query result

[samuel]

I'm using infopath as the front end to populate an access database.

I have the the main datasource defined.

Within the database, I have a linked table to a sql server table. This
linked table is also defined as a secondary data source within infopath

On my infopath form, I have a txt box called mnemonic (main datasource)

I want the user to be able to type in the mnemonic.

After the mnemonic is entered, I want a query to be run against the linked
sql server table (secondary data source)

I then want the infopath form to display the following fields from the query

Description and AWP

I will then write a rule to store these two fields in the access database.

I hope this makes sense.