Modify the Week 12 Assignment to use a DBComboBox control for some type of lookup capability. This means that you must have two tables in your database that have a logical relationship.
An example of this relationship is that a Full State Name be displayed in the ComboBox for display on the main form. The table would physically store the state abbreviation. The second table would in this example, contain a column for the abbreviation and a columns for the full name.
A second example would a Mail Order application with various shipping methods. The shippers are coded in the shipping info table, but a second table will contain the full name of the shipper. The main form will use a DBListBox to show the full name, but the bound column will contain the shippers code.
See Example 4 for help if necessary.
Here is a list of the Program Grading Criteria