Add a self lookup facility to your database (1 Viewer)

You can take advantage of the data you have already entered into your database with a self look up. A typical example would be you have entered the city, it would be handy if you could look the city's up in the combo box and have them automatically entered in the new record.

There is a set of videos here that demonstrate how to do this.