Hi everybody

After a long stint with MS Access, i have recently started moving to Vb.net with ms sql in the back end

What i know : in ms sql
i have done the tables
relations are done

in vb.net
know to connect to back end
know to create forms
know to link the form with data

my doubt :
in ms access, i create a query using multiple tables and use that query to create a form
is this possible in vb.net

how do i create a query and use this query as a form
the example is :
i have ... vendors table
purchase table
when i create a new purchase order, on the purchase order form, i select the vendor code from a combo box and all other related vendor data like name, address and so on gets populated in the respective text box
how do i do this
please help
thanks in advance

Hemanth