Here is a summary of the project:


The first form displays information about our Clients, it has a combobox and several textboxes. After selecting the client name from the combobox, the client details (address, phone, email, etc.) will be populated in the textboxes on the same form. This form should allow for client info to be edited, deleted, or added to the table. By default, the first client in the table will be displayed in the combobox along with the assoiciated detail information in each of the textboxes. Each time the combobox selection changes, the textboxes are updated to show the detail info for the new selection.

There is also a button on this form that when clicked will display another form showing all the employees who work for that particular client. Therefore, the ID number from the client table is a primary key that is linked to a foreign key in the emplyee table.

I am confused as to what fields need to be added to the combobox since I'll need the ID number to determine which employees to display.