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:
Fields in Consultant Table:
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.