I am trying to elobrate more:

I am making application using VS in 2003.

I have create 2 Tables, a) Invoice b) Consultant in MS Access.
I have created 2 Form for above tables usine Visual Studio 2003.

I have created both the below forms in VS 2003, All i need to connect them to associated table in MS access.. Pls suggest for that too..
Fields in Invoice Table:

  1. First Name
  2. Last Name
  3. Company
  4. Invoice Approver
  5. ProjectID
  6. Description

Fields in Consultant Table:

  1. First Name
  2. Last Name
  3. Company
  4. Manager
  5. ProjectID

I want when I select ProjectID in Consultant form it will instantly display or update the FirstName, LastName, Company, Description and Manager which is saved in Invoice table.

Hope I am clear, let me know if anything is needed.

Regards

Eigen.