How to autofill information in Form?

Hi,

I have 10 fields in my Invoice and I want this form will automatically fetch data from Consultant Table.

For exmaple, In Invoice Form If I have selected the Constultant ID then rest of the information like First Name , Last Name, Company etc. will automatically get updated in form instantly and I can save and enter new invoice.

Regards
Eigen.

Based on the details you included in your question I can only suggest you check here.

@DeathByVisualStudio: Because browser add ons are exactly what he's looking for

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.

@Eigenvector: Unfortunately even with the details you've provided there is no single answer.

I suggest you start with this walk-through on Connecting to Data in an Access Database. This will show you how to make your MS Access database a datasource in your Visual Studio project. Then use the Windows Forms Data Binding guide to learn how to wire up your datasource to your forms.

These are all MSDN reference materials. Learn to search them and search them well.

5 hours ago, GoddersUK wrote

@DeathByVisualStudio: Because browser add ons are exactly what he's looking for

Just working with the data provided...