Lookup tables

- [Instructor] Lookup tables are used to supply…a drop-list of values acceptable for a given field.…For example, in our State field here,…I could set up a separate table…of the 50 U.S. state, two-character abbreviations,…making it a lot easier to choose a state…when you're entering someone's address.…The way I'm gonna use it here, however,…is I'm gonna build a lookup table for…the status of a customer.…It's going to replace our validation rule.…Validation rules are good, but it's not until someone…makes a mistake that they find out…that there's a fixed list of things they can use.…

If you set up a lookup table, they know right away…because when they see the field pop up on a form…or when they hit it in Datasheet view,…they see the drop-arrow,…and that tells them that there's a list of choices.…Let's get rid of the validation rule.…I'm just gonna delete it.…There we go, I can leave the default value.…And then I'm going to go up here to Status…and hit the drop-arrow on the Data Type…and choose Lookup Wizard.…Now, the Lookup Wizard starts offering me the two ways…