Lookup Tables
Zip Lookup Table
The Members application makes extensive use of lookup tables. The reason for this is to ensure consistancy in data entry. They also save some time and space. For example, Lookup_Zip is used everywhere that a zip code is used in the application. Then only the zip code is entered in the two tables where addresses are used. Then the City and State are looked up and displayed in a calculated field nearby. If a zip code is missing in the lookup table, a click on that calculated field where the city, state should be displayed, opens the Lookup_Zip for you to enter the zip code, city and state. Once this is entered it will not be necessary to enter that city and state again. From that time, programming in the application will provide the information where needed.
Class & Volunteer Area Tables
 |
 |
These tables are used for data entry into the Members Entry form. Class describes the kind of relationship with Mission Granbury, such as Auxiliary, Staff, Donor, and a number of other categories.
VArea is short for Volunteer Area, and describes the kind of work you do for Mission Granbury. Examples are Ada Carey Center, Food Pantry, etc.
Corporate Category Table 
The kinds of organizations associated with Mission Granbury vary widely. For the purposes of this application all the organizations are considered corporations because of the nature of the data they share. The Categories include clubs, churches, governmental entities, and commercial businesses.
Field Name "Cat" is a code for the second field, Category name. The Description gives the details of what is meant by the category if it seems ambiguous at the time of data entry.
Lookup Month Table
This application deals with dates, all of which are entered as short dates (m/d/yy) or just mmdd in and the case or birthdays. The Lookup-Month table is used to calculate reports that use month names or the 3-letter abreviations for the month names. Presently, we're using this table for reports on birthdays.
Lookup Events & Awards Tables
|
Whether entering the events attended or awards presented consistency is important if we ever have hope of having those things accurately reported later. |
|