SMART LOOKUP (COMBO BOXES) IN THE MOVIES TABLE

PROBLEM:

The lookup combo boxes for actors & directors show all of the celebrities.

It would be better to show only the appropriate names for each category.

METHOD:

Work backwards from the problem goal to sub-goals.

GOAL:

Make 2 lookup lists (Actors Only, Directors Only)

SUB-GOAL:

Make the lists using 2 queries (actors only & directors only)

- based on Celebrities table

SUB-SUB-GOAL:

1. Redesign Celebrities table to allow us to categorize the celebrities

- according to claim to fame

- this is a new field

- permit a celibrity to have 2 claims to fame

- CLAIM TO FAME 1, CLAIM TO FAME 2

2. Categorize the celebrities in the table

SUB-SUB-SUB-GOAL:

As a convenience make a lookup combo box to help categorize celebrities

- store the claims to fame in a separate claim-to-fame table

- then make the combo boxes in the celebrities using this table

SUB-SUB-SUB-SUB-GOAL:

Import the Claim to Fame table

- from the TABLES-TO-IMPORT Excel file