Hi All,

I am using vs2005 with access database.
Developing a new application. I am the new one to the application development.
This is what my situation which takes my time towards searching a reference
but no where it is found:

There is 2 tables named tblbill(contains VendorID & TruckID) and
tblvendor(contains VendorID & VendorName)
Where my user wants to display the vendorname against what he selected the TruckID

I know how to catch the VendorID in selection of the TruckID
But doesn't know how to retrieve the Vendorname based on the vendorID.
Please show me a sample to solve this problem...

Kindly help me,
Thanks in advance....

Edited by vijaycare

4 Years
Discussion Span
Last Post by vijaycare

With the following data

    VendorID   VendorName
    1          Sam
    2          George
    3          Fred
    4          Orville

    VendorID   TruckID
    1          101
    2          143
    3          212
    4          971

The following query

    select tblvendor.VendorName,tblvendor.VendorID,tblbill.truckid
      from tblbill inner join tblvendor 
        on tblbill.VendorID = tblvendor.VendorID

produces the following output

        VendorName   VendorID   TruckID
        Sam          1          101
        George       2          143
        Fred         3          212
        Orville      4          971

Edited by Reverend Jim

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.