Ive created a VB Express 2005 project containing a Projects form and a Clients form, both of which are bound to SQL database tables. Ive also created a foreign key link on ClientID (numeric-integer) so that there can be multiple projects assigned to any given client. The basic functionality of these forms works OK.
My question is this: I have a textbox in the Project form for ClientID and a textbox for the Client Name.
What is the best way to allow the user to select the client he wishes for the intended project and then display it immediately in the textbox before the rest of the form is filled out and saved?