:Base la1n50en.hlp>Steps :Title Approach Help :Index Lotus Chart Help=lc1n21en.hlp :Index TeamMail Help=tm1n11en.hlp :Index Lotus Customer Support Help=cs1n97en.hlp :Link lasn50en.hlp 1 Getting Started 2 Using Help=H_USING_HELP_REF@la1n50en.hlp>Overview 2 Getting help from the Internet=H_GETTING_HELP_FROM_THE_INTERNET_STEPS@la1n50en.hlp>Steps 2 Planning a Database 3 Why build a database?=H_WHY_BUILD_A_DATABASE_REF@la1n50en.hlp>Overview 3 What will a database do for you?=H_WHAT_WILL_A_DATABASE_DO_FOR_YOU_REF@la1n50en.hlp>Overview 3 What questions will you ask the database?=H_WHAT_QUESTIONS_WILL_YOU_ASK_THE_DATABASE_REF@la1n50en.hlp>Overview 3 What kind of data?=H_WHAT_KIND_OF_DATA_REF@la1n50en.hlp>Overview 3 Identify main ideas and group fields under them=H_IDENTIFY_MAIN_IDEAS_AND_GROUP_FIELDS_UNDER_THEM_REF@la1n50en.hlp>Overview 3 Make connections between the groups=H_MAKE_CONNECTIONS_BETWEEN_THE_GROUPS_REF@la1n50en.hlp>Overview 3 Check for redundant information=H_CHECK_FOR_REDUNDANT_INFORMATION_REF@la1n50en.hlp>Overview 3 Use SmartMasters=H_USE_SMARTMASTERS_REF@la1n50en.hlp>Overview 3 Build the database in Approach=H_BUILD_THE_DATABASE_IN_APPROACH_REF@la1n50en.hlp>Overview 2 Did You Know. . . 3 Browse is for data, Design is for style=H_BROWSE_IS_FOR_DATA_DESIGN_IS_FOR_STYLE_REF@la1n50en.hlp>Overview 3 Approach saves data automatically=H_APPROACH_SAVES_DATA_AUTOMATICALLY_REF@la1n50en.hlp>Overview 3 A sort is not a find=H_A_SORT_IS_NOT_A_FIND_REF@la1n50en.hlp>Overview 3 Select Print Preview to see report summaries=H_SELECT_PRINT_PREVIEW_TO_SEE_REPORT_SUMMARIES_REF@la1n50en.hlp>Overview 1 Top 10 Tasks 2 Importing and Exporting Data 3 Importing Data 4 Importing data into databases=H_IMPORTING_DATA_INTO_DATABASES_STEPS@la1n50en.hlp>Steps 4 Opening databases created in other applications=H_OPENING_DATABASES_CREATED_IN_OTHER_APPLICATIONS_STEPS@la1n50en.hlp>Steps 4 Creating databases from spreadsheets=H_CREATING_DATABASES_FROM_SPREADSHEETS_STEPS@la1n50en.hlp>Steps 4 Creating databases from delimited text files=H_CREATING_DATABASES_FROM_DELIMITED_TEXT_FILES_STEPS@la1n50en.hlp>Steps 4 Creating databases from fixed-length text files=H_CREATING_DATABASES_FROM_FIXEDLENGTH_TEXT_FILES_STEPS@la1n50en.hlp>Steps 4 Importing Approach files=H_IMPORTING_APPROACH_FILES_STEPS@la1n50en.hlp>Steps 4 Mapping fields=H_MAPPING_FIELDS_REF@la1n50en.hlp>Overview 4 Pasting pictures in fields=H_PASTING_PICTURES_IN_FIELDS_STEPS@la1n50en.hlp>Steps 3 Exporting Data 4 Exporting data from Approach=H_EXPORTING_DATA_FROM_APPROACH_STEPS@la1n50en.hlp>Steps 4 Copying PicturePlus pictures to a file=H_COPYING_PICTUREPLUS_PICTURES_TO_A_FILE_STEPS@la1n50en.hlp>Steps 2 Creating Databases 3 Creating a new database from scratch=H_CREATING_A_NEW_DATABASE_FROM_SCRATCH_STEPS@la1n50en.hlp>Steps 3 Creating a new database with a set of ready-to-use fields=H_CREATING_A_NEW_DATABASE_WITH_A_SET_OF_READYTOUSE_FIELDS_STEPS@la1n50en.hlp>Steps 3 Creating a new database that is a ready-to-use application=H_CREATING_A_NEW_DATABASE_THAT_IS_A_READYTOUSE_APPLICATION_STEPS@la1n50en.hlp>Steps 3 Opening databases created in other applications=H_OPENING_DATABASES_CREATED_IN_OTHER_APPLICATIONS_STEPS@la1n50en.hlp>Steps 3 Creating databases from spreadsheets=H_CREATING_DATABASES_FROM_SPREADSHEETS_STEPS@la1n50en.hlp>Steps 3 Creating databases from delimited text files=H_CREATING_DATABASES_FROM_DELIMITED_TEXT_FILES_STEPS@la1n50en.hlp>Steps 3 Creating databases from fixed-length text files=H_CREATING_DATABASES_FROM_FIXEDLENGTH_TEXT_FILES_STEPS@la1n50en.hlp>Steps 3 Creating custom SmartMasters=H_CREATING_CUSTOM_SMARTMASTERS_STEPS@la1n50en.hlp>Steps 3 Mapping fields=H_MAPPING_FIELDS_REF@la1n50en.hlp>Overview 2 Creating and Formatting Fields 3 Defining Fields for Databases 4 Overview: Types of fields=H_TYPES_OF_FIELDS_OVER@la1n50en.hlp>Overview 4 Adding fields to a database=H_ADDING_FIELDS_TO_A_DATABASE_STEPS@la1n50en.hlp>Steps 4 Writing formulas for calculated fields=H_WRITING_FORMULAS_FOR_CALCULATED_FIELDS_STEPS@la1n50en.hlp>Steps 4 Calculating a summary across records=H_CALCULATING_A_SUMMARY_ACROSS_RECORDS_STEPS@la1n50en.hlp>Steps 4 Editing fields of a database=H_EDITING_FIELDS_OF_A_DATABASE_STEPS@la1n50en.hlp>Steps 4 Specifying a key field for a Paradox database=H_SPECIFYING_A_KEY_FIELD_FOR_A_PARADOX_DATABASE_STEPS@la1n50en.hlp>Steps 4 Deleting fields from a database=H_DELETING_FIELDS_FROM_A_DATABASE_STEPS@la1n50en.hlp>Steps 3 Displaying Fields in Views 4 Overview: Fields=H_FIELDS_OVER@la1n50en.hlp>Overview 4 Adding fields to a view=H_ADDING_FIELDS_TO_A_VIEW_STEPS@la1n50en.hlp>Steps 4 Displaying fields as scrolling lists=H_DISPLAYING_FIELDS_AS_SCROLLING_LISTS_STEPS@la1n50en.hlp>Steps 4 Displaying fewer values in a scrolling list=H_DISPLAYING_FEWER_VALUES_IN_A_SCROLLING_LIST_STEPS@la1n50en.hlp>Steps 4 Displaying descriptive values in a scrolling list=H_DISPLAYING_DESCRIPTIVE_VALUES_IN_A_SCROLLING_LIST_STEPS@la1n50en.hlp>Steps 4 Displaying fields as check boxes=H_DISPLAYING_FIELDS_AS_CHECK_BOXES_STEPS@la1n50en.hlp>Steps 4 Displaying fields as radio buttons=H_DISPLAYING_FIELDS_AS_RADIO_BUTTONS_STEPS@la1n50en.hlp>Steps 4 Rearranging a set of radio buttons or check boxes=H_REARRANGING_A_SET_OF_RADIO_BUTTONS_OR_CHECK_BOXES_STEPS@la1n50en.hlp>Steps 2 Entering and Editing Data 3 Adding, Deleting, and Hiding Records 4 Adding new records=H_ADDING_NEW_RECORDS_STEPS@la1n50en.hlp>Steps 4 Duplicating records=H_DUPLICATING_RECORDS_STEPS@la1n50en.hlp>Steps 4 Deleting specific records=H_DELETING_SPECIFIC_RECORDS_STEPS@la1n50en.hlp>Steps 4 Deleting a found set of records=H_DELETING_A_FOUND_SET_OF_RECORDS_STEPS@la1n50en.hlp>Steps 4 Deleting all records=H_DELETING_ALL_RECORDS_STEPS@la1n50en.hlp>Steps 4 Hiding records=H_HIDING_RECORDS_STEPS@la1n50en.hlp>Steps 4 Showing hidden records=H_SHOWING_HIDDEN_RECORDS_STEPS@la1n50en.hlp>Steps 3 Entering Data in Fields 4 Selecting fields=H_SELECTING_FIELDS_STEPS@la1n50en.hlp>Steps 4 Entering text in text or memo fields=H_ENTERING_TEXT_IN_TEXT_OR_MEMO_FIELDS_STEPS@la1n50en.hlp>Steps 4 Entering values in numeric fields=H_ENTERING_VALUES_IN_NUMERIC_FIELDS_STEPS@la1n50en.hlp>Steps 4 Entering values in Boolean fields=H_ENTERING_VALUES_IN_BOOLEAN_FIELDS_STEPS@la1n50en.hlp>Steps 4 Entering dates in date fields=H_ENTERING_DATES_IN_DATE_FIELDS_STEPS@la1n50en.hlp>Steps 4 Entering times in time fields=H_ENTERING_TIMES_IN_TIME_FIELDS_STEPS@la1n50en.hlp>Steps 4 Duplicating a value from the last record modified=H_DUPLICATING_VALUES_FROM_THE_LAST_RECORD_MODIFIED_STEPS@la1n50en.hlp>Steps 4 Selecting from a drop-down box=H_SELECTING_FROM_A_DROPDOWN_BOX_STEPS@la1n50en.hlp>Steps 4 Selecting radio buttons or check boxes=H_SELECTING_RADIO_BUTTONS_OR_CHECK_BOXES_STEPS@la1n50en.hlp>Steps 4 Entering the same data into many records=H_ENTERING_THE_SAME_DATA_INTO_MANY_RECORDS_STEPS@la1n50en.hlp>Steps 4 Pasting pictures in fields=H_PASTING_PICTURES_IN_FIELDS_STEPS@la1n50en.hlp>Steps 4 Drawing in PicturePlus fields=H_DRAWING_IN_PICTUREPLUS_FIELDS_STEPS@la1n50en.hlp>Steps 3 Moving to Another Record 4 Moving through records one record at a time=H_MOVING_ONE_RECORD_AT_A_TIME_STEPS@la1n50en.hlp>Steps 4 Moving to the first or last record=H_MOVING_TO_THE_FIRST_OR_LAST_RECORD_STEPS@la1n50en.hlp>Steps 4 Moving to a specific record=H_MOVING_TO_A_SPECIFIC_RECORD_STEPS@la1n50en.hlp>Steps 3 Checking Spelling 4 Checking spelling=H_RUNNING_THE_SPELLING_CHECKER_STEPS@la1n50en.hlp>Steps 4 Editing the user dictionary=H_EDITING_THE_USER_DICTIONARY_STEPS@la1n50en.hlp>Steps 4 Changing to another language in the main dictionary=H_CHANGING_TO_ANOTHER_MAIN_DICTIONARY_STEPS@la1n50en.hlp>Steps 4 Setting options for checking spelling=H_SETTING_OPTIONS_FOR_CHECKING_SPELLING_STEPS@la1n50en.hlp>Steps 3 Finding and Replacing Text 4 Finding text=H_FINDING_TEXT_STEPS@la1n50en.hlp>Steps 4 Replacing text=H_REPLACING_TEXT_STEPS@la1n50en.hlp>Steps 2 Laying Out and Styling Views 3 Overview: InfoBox=H_INFOBOX_OVER@la1n50en.hlp>Overview 3 Working with Named Styles 4 Overview: Working with named styles=H_WORKING_WITH_NAMED_STYLES_OVER@la1n50en.hlp>Overview 4 Defining new named styles=H_DEFINING_NEW_NAMED_STYLES_STEPS@la1n50en.hlp>Steps 4 Defining a named style based on an existing object's properties=H_DEFINING_A_NAMED_STYLE_BASED_ON_AN_EXISTING_OBJECTS_PROPERTIES_STEPS@la1n50en.hlp>Steps 4 Redefining named styles=H_REDEFINING_NAMED_STYLES_STEPS@la1n50en.hlp>Steps 4 Applying named styles=H_APPLYING_NAMED_STYLES_STEPS@la1n50en.hlp>Steps 4 Managing named styles=H_MANAGING_NAMED_STYLES_STEPS@la1n50en.hlp>Steps 4 Copying named styles=H_COPYING_NAMED_STYLES_STEPS@la1n50en.hlp>Steps 4 Editing named styles=H_EDITING_NAMED_STYLES_STEPS@la1n50en.hlp>Steps 4 Deleting named styles=H_DELETING_NAMED_STYLES_STEPS@la1n50en.hlp>Steps 3 Adding Objects to the Background of a View 4 Drawing geometric objects=H_DRAWING_GEOMETRIC_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Adding text blocks=H_ADDING_TEXT_BLOCKS_STEPS@la1n50en.hlp>Steps 4 Adding multiple objects to a view=H_ADDING_MULTIPLE_OBJECTS_TO_A_VIEW_STEPS@la1n50en.hlp>Steps 4 Pasting pictures in views=H_PASTING_PICTURES_IN_VIEWS_STEPS@la1n50en.hlp>Steps 4 Inserting dates or times=H_INSERTING_DATES_OR_TIMES_STEPS@la1n50en.hlp>Steps 4 Adding buttons to run macros=H_ADDING_MACRO_BUTTONS_STEPS@la1n50en.hlp>Steps 3 Changing Objects and Text 4 Applying properties from another object (Fast Format)=H_APPLYING_PROPERTIES_FROM_ANOTHER_OBJECT_STEPS@la1n50en.hlp>Steps 4 Selecting objects=H_SELECTING_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Resizing objects=H_RESIZING_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Moving objects=H_MOVING_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Selecting text in text blocks=H_SELECTING_TEXT_IN_A_TEXT_BLOCK_STEPS@la1n50en.hlp>Steps 4 Cutting or copying objects or text=H_CUTTING_OR_COPYING_OBJECTS_OR_TEXT_STEPS@la1n50en.hlp>Steps 4 Changing the width of lines or borders=H_CHANGING_THE_WIDTH_OF_LINES_OR_BORDERS_STEPS@la1n50en.hlp>Steps 4 Creating partial borders=H_CREATING_PARTIAL_BORDERS_STEPS@la1n50en.hlp>Steps 4 Making objects and views transparent=H_MAKING_OBJECTS_AND_VIEWS_TRANSPARENT_STEPS@la1n50en.hlp>Steps 4 Putting objects and fields in the tab order=H_PUTTING_OBJECTS_AND_FIELDS_IN_THE_TAB_ORDER_STEPS@la1n50en.hlp>Steps 4 Changing the tab order on views=H_CHANGING_THE_TAB_ORDER_ON_VIEWS_STEPS@la1n50en.hlp>Steps 3 Working with More Than One Object at a Time 4 Grouping and ungrouping objects=H_GROUPING_AND_UNGROUPING_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Changing the order of overlapping objects=H_CHANGING_THE_ORDER_OF_OVERLAPPING_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Aligning and distributing objects=H_ALIGNING_AND_DISTRIBUTING_OBJECTS_STEPS@la1n50en.hlp>Steps 3 Editing Views 4 Naming views=H_NAMING_VIEWS_AND_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Selecting a main database for a view=H_SELECTING_A_MAIN_DATABASE_FOR_A_VIEW_STEPS@la1n50en.hlp>Steps 4 Changing the menu for a view=H_CHANGING_THE_MENU_FOR_A_VIEW_STEPS@la1n50en.hlp>Steps 4 Hiding views=H_HIDING_VIEWS_STEPS@la1n50en.hlp>Steps 4 Redisplaying hidden views=H_REDISPLAYING_HIDDEN_VIEWS_STEPS@la1n50en.hlp>Steps 4 Showing more of the view by hiding its margins=H_SHOWING_MORE_OF_THE_VIEW_BY_HIDING_ITS_MARGINS_STEPS@la1n50en.hlp>Steps 4 Changing the width of the view border=H_CHANGING_THE_WIDTH_OF_LINES_OR_BORDERS_STEPS@la1n50en.hlp>Steps 4 Creating partial borders for views=H_CREATING_PARTIAL_BORDERS_STEPS@la1n50en.hlp>Steps 4 Duplicating views=H_DUPLICATING_VIEWS_STEPS@la1n50en.hlp>Steps 4 Deleting views=H_DELETING_VIEWS_STEPS@la1n50en.hlp>Steps 4 Deleting elements of a view=H_DELETING_ELEMENTS_OF_A_VIEW_STEPS@la1n50en.hlp>Steps 4 Adding fields to a view=H_ADDING_FIELDS_TO_A_VIEW_STEPS@la1n50en.hlp>Steps 2 Joining Databases 3 Joining database files=H_JOINING_DATABASE_FILES_STEPS@la1n50en.hlp>Steps 3 Setting options for a join=H_SETTING_OPTIONS_FOR_A_JOIN_STEPS@la1n50en.hlp>Steps 3 Making calculated fields available for joins=H_MAKING_CALCULATED_FIELDS_AVAILABLE_FOR_JOINS_STEPS@la1n50en.hlp>Steps 3 Unjoining database files=H_UNJOINING_DATABASE_FILES_STEPS@la1n50en.hlp>Steps 3 Overview: Joined databases=H_JOINED_DATABASES_OVER@la1n50en.hlp>Overview 3 Overview: Main and detail databases in a view=H_MAIN_AND_DETAIL_DATABASES_IN_A_VIEW_OVER@la1n50en.hlp>Overview 3 Overview: One-to-many, many-to-one, and one-to-one relationships=H_ONE_TO_MANY_MANY_TO_ONE_AND_ONE_TO_ONE_RELATIONSHIPS_OVER@la1n50en.hlp>Overview 3 Overview: Many-to-many relationships=H_MANY_TO_MANY_RELATIONSHIPS_OVER@la1n50en.hlp>Overview 3 Overview: Alias joins=H_ALIAS_JOINS_OVER@la1n50en.hlp>Overview 3 Joining a database to itself (alias join)=H_JOINING_A_DATABASE_TO_ITSELF_STEPS@la1n50en.hlp>Steps 2 Finding Records 3 Overview: The found set=H_THE_FOUND_SET_OVER@la1n50en.hlp>Overview 3 Showing all records=H_SHOWING_ALL_RECORDS_STEPS@la1n50en.hlp>Steps 3 Finding Records Using the Find Assistant 4 Overview: Finding records with the Find Assistant=H_FINDING_RECORDS_WITH_THE_FIND_ASSISTANT_OVER@la1n50en.hlp>Overview 4 Selecting a find type with the Find Assistant=H_SELECTING_A_FIND_TYPE_WITH_THE_FIND_ASSISTANT_REF@la1n50en.hlp>Overview 4 Creating a find condition with the Find Assistant=H_CREATING_A_FIND_CONDITION_WITH_THE_FIND_ASSISTANT_STEPS@la1n50en.hlp>Steps 4 Finding duplicate records with the Find Assistant=H_FINDING_DUPLICATE_RECORDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n50en.hlp>Steps 4 Finding distinct records with the Find Assistant=H_FINDING_DISTINCT_OR_UNIQUE_RECORDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n50en.hlp>Steps 4 Finding the top or lowest values with the Find Assistant=H_FINDING_THE_TOP_OR_LOWEST_VALUES_WITH_THE_FIND_ASSISTANT_STEPS@la1n50en.hlp>Steps 4 Sorting fields with the Find Assistant=H_SORTING_FIELDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n50en.hlp>Steps 3 Finding Records Using Query by Box 4 Finding records using Query by Box=H_FINDING_RECORDS_USING_QUERY_BY_BOX_STEPS@la1n50en.hlp>Steps 4 Overview: Defining find conditions graphically in Query by Box=H_DEFINING_FIND_CONDITIONS_GRAPHICALLY_IN_QUERY_BY_BOX_OVER@la1n50en.hlp>Overview 4 Overview: Multiple find conditions in Query by Box=H_MULTIPLE_FIND_CONDITIONS_IN_QUERY_BY_BOX_OVER@la1n50en.hlp>Overview 3 Finding Records Using a Blank View 4 Creating find requests=H_CREATING_FIND_REQUESTS_STEPS@la1n50en.hlp>Steps 4 Finding records that satisfy multiple conditions (AND)=H_FINDING_RECORDS_THAT_SATISFY_MULTIPLE_CONDITIONS_(AND)_STEPS@la1n50en.hlp>Steps 4 Finding records that satisfy at least one of several conditions (OR)=H_FIND_RECORDS_TO_SATISFY_ONE_OF_SEVERAL_CONDITIONS_(OR)_STEPS@la1n50en.hlp>Steps 4 Finding records with OR conditions in more than one field=H_FINDING_RECORDS_WITH_OR_CONDITIONS_IN_MORE_THAN_ONE_FIELD_STEPS@la1n50en.hlp>Steps 4 Finding text with wildcards=H_FINDING_TEXT_WITH_WILDCARDS_STEPS@la1n50en.hlp>Steps 4 Finding case-sensitive text=H_FINDING_CASESENSITIVE_TEXT_STEPS@la1n50en.hlp>Steps 4 Finding a word that sounds like another=H_FINDING_A_WORD_THAT_SOUNDS_LIKE_ANOTHER_STEPS@la1n50en.hlp>Steps 4 Finding numbers, dates, and times=H_FINDING_NUMBERS_DATES_AND_TIMES_STEPS@la1n50en.hlp>Steps 4 Finding values in a range=H_FINDING_VALUES_IN_A_RANGE_STEPS@la1n50en.hlp>Steps 4 Finding today's date=H_FINDING_TODAYS_DATE_STEPS@la1n50en.hlp>Steps 4 Finding radio button and check box settings=H_FINDING_RADIO_BUTTON_AND_CHECK_BOX_SETTINGS_STEPS@la1n50en.hlp>Steps 4 Finding blank or nonblank fields=H_FINDING_BLANK_OR_NONBLANK_FIELDS_STEPS@la1n50en.hlp>Steps 4 Using If statements to find data=H_USING_IF_STATEMENTS_TO_FIND_DATA_STEPS@la1n50en.hlp>Steps 4 Repeating finds=H_REPEATING_FINDS_STEPS@la1n50en.hlp>Steps 3 Creating Named Finds 4 Naming finds with the Find Assistant=H_NAMING_FINDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n50en.hlp>Steps 4 Naming and reviewing finds with the Find Assistant=H_NAMING_AND_REVIEWING_FINDS_WITH_THE_FIND_ASSISTANT_REF@la1n50en.hlp>Overview 4 Naming finds based on find requests=H_NAMING_FINDS_BASED_ON_FIND_REQUESTS_STEPS@la1n50en.hlp>Steps 4 Editing named finds=H_EDITING_NAMED_FINDS_STEPS@la1n50en.hlp>Steps 4 Copying named finds=H_COPYING_NAMED_FINDS_STEPS@la1n50en.hlp>Steps 4 Deleting named finds=H_DELETING_NAMED_FINDS_STEPS@la1n50en.hlp>Steps 4 Running named finds=H_RUNNING_NAMED_FINDS_STEPS@la1n50en.hlp>Steps 2 Sorting Records 3 Specifying a sort order=H_SPECIFYING_A_SORT_ORDER_STEPS@la1n50en.hlp>Steps 3 Sorting records by a field in a view (Ascending)=H_SORTING_RECORDS_BY_A_FIELD_IN_A_VIEW_ASCENDING_STEPS@la1n50en.hlp>Steps 3 Sorting records by a field in a view (Descending)=H_SORTING_RECORDS_BY_A_FIELD_IN_A_VIEW_DESCENDING_STEPS@la1n50en.hlp>Steps 3 Setting a default sort order for looking at records in Browse=H_SETTING_A_DEFAULT_SORT_ORDER_FOR_RECORDS_IN_BROWSE_STEPS@la1n50en.hlp>Steps 3 Setting a default sort order for a repeating panel=H_SORTING_RECORDS_IN_REPEATING_PANELS_STEPS@la1n50en.hlp>Steps 2 Creating Reports 3 Overview: Reports=H_REPORTS_OVER@la1n50en.hlp>Overview 3 Overview: Report panels=H_REPORT_PANELS_OVER@la1n50en.hlp>Overview 3 Using PowerClick Reporting 4 Creating a PowerClick report with a grand total=H_CREATING_A_POWERCLICK_REPORT_WITH_A_GRAND_TOTAL_STEPS@la1n50en.hlp>Steps 4 Creating a PowerClick report with subtotals for groups=H_CREATING_A_POWERCLICK_REPORT_WITH_SUBTOTALS_FOR_GROUPS_STEPS@la1n50en.hlp>Steps 4 Grouping records in reports=H_GROUPING_RECORDS_IN_REPORTS_STEPS@la1n50en.hlp>Steps 4 Adding summaries to reports=H_ADDING_SUMMARIES_TO_REPORTS_STEPS@la1n50en.hlp>Steps 3 Creating Reports 4 Deciding what new reports look like=H_DECIDING_WHAT_NEW_REPORTS_LOOK_LIKE_REF@la1n50en.hlp>Overview 4 Adding fields to new reports=H_ADDING_FIELDS_TO_NEW_REPORTS_STEPS@la1n50en.hlp>Steps 4 Grouping records in new reports=H_GROUPING_RECORDS_IN_NEW_REPORTS_STEPS@la1n50en.hlp>Steps 4 Adding repeating fields to new repeating panel reports=H_ADDING_REPEATING_FIELDS_TO_NEW_REPEATING_PANEL_REPORTS_STEPS@la1n50en.hlp>Steps 4 Adding summaries to new reports=H_ADDING_SUMMARIES_TO_NEW_REPORTS_STEPS@la1n50en.hlp>Steps 3 Summarizing Data in Reports 4 Adding summaries to reports=H_ADDING_SUMMARIES_TO_REPORTS_STEPS@la1n50en.hlp>Steps 4 Summary calculations=H_SUMMARY_CALCULATIONS_REF@la1n50en.hlp>Overview 4 Choosing which records go into a summary=H_CHOOSING_WHICH_RECORDS_GO_INTO_A_SUMMARY_STEPS@la1n50en.hlp>Steps 4 Moving summaries=H_MOVING_SUMMARIES_STEPS@la1n50en.hlp>Steps 3 Revising Reports 4 Adding fields to reports=H_ADDING_FIELDS_TO_REPORTS_STEPS@la1n50en.hlp>Steps 4 Creating charts in reports=H_CREATING_CHARTS_IN_REPORTS_STEPS@la1n50en.hlp>Steps 4 Selecting, moving, and deleting report panels=H_SELECTING_MOVING_AND_DELETING_REPORT_PANELS_STEPS@la1n50en.hlp>Steps 4 Grouping records in reports=H_GROUPING_RECORDS_IN_REPORTS_STEPS@la1n50en.hlp>Steps 4 Changing the number of columns in reports=H_CHANGING_THE_NUMBER_OF_COLUMNS_IN_REPORTS_STEPS@la1n50en.hlp>Steps 4 Moving and resizing report columns=H_MOVING_AND_RESIZING_REPORT_COLUMNS_STEPS@la1n50en.hlp>Steps 4 Showing missing records in a report=H_SHOWING_ALL_GROUPS_IN_A_REPORT_STEPS@la1n50en.hlp>Steps 3 Printing Reports 4 Reducing or expanding sections of reports when printing=H_PRINTING_REPORTS_STEPS@la1n50en.hlp>Steps 4 Creating title pages for reports=H_CREATING_TITLE_PAGES_FOR_REPORTS_STEPS@la1n50en.hlp>Steps 4 Adding dates, times, or page numbers to reports=H_ADDING_DATES_TIMES_OR_PAGE_NUMBERS_TO_REPORTS_STEPS@la1n50en.hlp>Steps 4 Changing the number of columns in reports=H_CHANGING_THE_NUMBER_OF_COLUMNS_IN_REPORTS_STEPS@la1n50en.hlp>Steps 4 Paginating reports=H_PAGINATING_REPORTS_STEPS@la1n50en.hlp>Steps 2 Previewing and Printing 3 Overview: Printing Approach views=H_PRINTING_APPROACH_VIEWS_OVER@la1n50en.hlp>Overview 3 Downloading data before previewing=H_DOWNLOADING_DATA_BEFORE_PREVIEWING_STEPS@la1n50en.hlp>Steps 3 Previewing views=H_PREVIEWING_VIEWS_STEPS@la1n50en.hlp>Steps 3 Printing views=H_PRINTING_VIEWS_STEPS@la1n50en.hlp>Steps 3 Formatting worksheets or crosstabs for printing=H_FORMATTING_WORKSHEETS_OR_CROSSTABS_FOR_PRINTING_STEPS@la1n50en.hlp>Steps 3 Reducing or expanding sections of reports when printing=H_PRINTING_REPORTS_STEPS@la1n50en.hlp>Steps 3 Closing up extra space between fields=H_CLOSING_EXTRA_SPACE_BETWEEN_FIELDS_STEPS@la1n50en.hlp>Steps 3 Setting objects and fields to slide when printing=H_SETTING_OBJECTS_AND_FIELDS_TO_SLIDE_WHEN_PRINTING_STEPS@la1n50en.hlp>Steps 3 Preventing objects and fields from printing=H_PREVENTING_OBJECTS_AND_FIELDS_FROM_PRINTING_STEPS@la1n50en.hlp>Steps 3 Properties of printers=H_PROPERTIES_OF_PRINTERS_REF@la1n50en.hlp>Overview 3 Specifying the printer, paper, and orientation=H_SPECIFYING_THE_PRINTER_PAPER_AND_ORIENTATION_STEPS@la1n50en.hlp>Steps 3 Printing a list of file properties=H_APPROACH_FILE_PROPERTIES_REF@la1n50en.hlp>Overview 3 Printing a list of database fields=H_PRINTING_A_LIST_OF_DATABASE_FIELDS_STEPS@la1n50en.hlp>Steps 3 Printing a diagram of join relationships=H_PRINTING_A_DIAGRAM_OF_JOIN_RELATIONSHIPS_STEPS@la1n50en.hlp>Steps 3 Printing macros=H_PRINTING_MACRO_COMMANDS_STEPS@la1n50en.hlp>Steps 1 How Do I? 2 Manage Files 3 Create and Open Files 4 Approach file properties=H_APPROACH_FILE_PROPERTIES_REF@la1n50en.hlp>Overview 4 Welcome dialog box: Open an Existing Approach File=H_WELCOME_DIALOG_BOX_OPEN_AN_EXISTING_APPROACH_FILE_REF@la1n50en.hlp>Overview 4 Opening Approach files=H_OPENING_APPROACH_FILES_STEPS@la1n50en.hlp>Steps 4 Creating a new database from scratch=H_CREATING_A_NEW_DATABASE_FROM_SCRATCH_STEPS@la1n50en.hlp>Steps 4 Creating a new database with a set of ready-to-use fields=H_CREATING_A_NEW_DATABASE_WITH_A_SET_OF_READYTOUSE_FIELDS_STEPS@la1n50en.hlp>Steps 4 Creating a new database that is a ready-to-use application=H_CREATING_A_NEW_DATABASE_THAT_IS_A_READYTOUSE_APPLICATION_STEPS@la1n50en.hlp>Steps 4 Opening databases created in other applications=H_OPENING_DATABASES_CREATED_IN_OTHER_APPLICATIONS_STEPS@la1n50en.hlp>Steps 4 Creating databases from spreadsheets=H_CREATING_DATABASES_FROM_SPREADSHEETS_STEPS@la1n50en.hlp>Steps 4 Creating databases from delimited text files=H_CREATING_DATABASES_FROM_DELIMITED_TEXT_FILES_STEPS@la1n50en.hlp>Steps 4 Creating databases from fixed-length text files=H_CREATING_DATABASES_FROM_FIXEDLENGTH_TEXT_FILES_STEPS@la1n50en.hlp>Steps 4 Creating custom SmartMasters=H_CREATING_CUSTOM_SMARTMASTERS_STEPS@la1n50en.hlp>Steps 4 Identifying default directories=H_IDENTIFYING_DEFAULT_DIRECTORIES_STEPS@la1n50en.hlp>Steps 4 Mapping fields=H_MAPPING_FIELDS_REF@la1n50en.hlp>Overview 3 Protect Data, Assign Password Privileges 4 Overview: Passwords=H_PASSWORDS_OVER@la1n50en.hlp>Overview 4 TeamSecurity=H_TEAMSECURITY_REF@la1n50en.hlp>Overview 4 Defining password privileges using Copy=H_DEFINING_PASSWORD_PRIVILEGES_USING_COPY_STEPS@la1n50en.hlp>Steps 4 Defining password privileges using New =H_DEFINING_PASSWORD_PRIVILEGES_USING_NEW_STEPS@la1n50en.hlp>Steps 4 Editing password privileges=H_EDITING_PASSWORD_PRIVILEGES_STEPS@la1n50en.hlp>Steps 4 Deleting groups or users=H_DELETING_GROUPS_OR_USERS_STEPS@la1n50en.hlp>Steps 4 Confirming passwords=H_CONFIRMING_PASSWORDS_STEPS@la1n50en.hlp>Steps 4 Entering data using optimistic record locking=H_ENTERING_DATA_USING_OPTIMISTIC_RECORD_LOCKING_STEPS@la1n50en.hlp>Steps 3 Save, Close, and Delete Files 4 Saving Approach files=H_SAVING_APPROACH_FILES_STEPS@la1n50en.hlp>Steps 4 Saving a copy of an Approach file and a database file=H_SAVING_A_COPY_OF_AN_APPROACH_FILE_AND_A_DATABASE_FILE_STEPS@la1n50en.hlp>Steps 4 Saving a copy of an Approach file only=H_SAVING_A_COPY_OF_AN_APPROACH_FILE_ONLY_STEPS@la1n50en.hlp>Steps 4 Closing Approach files=H_CLOSING_APPROACH_FILES_STEPS@la1n50en.hlp>Steps 4 Deleting files=H_DELETING_FILES_STEPS@la1n50en.hlp>Steps 3 Create Query Files 4 Creating query files in Approach=H_CREATING_QUERY_FILES_IN_APPROACH_STEPS@la1n50en.hlp>Steps 4 Opening query files in Approach=H_OPENING_QUERY_FILES_IN_APPROACH_STEPS@la1n50en.hlp>Steps 4 Saving or exporting data from a query=H_SAVING_OR_EXPORTING_DATA_FROM_A_QUERY_STEPS@la1n50en.hlp>Steps 3 Create an SQL SELECT Statement with the SQL Assistant 4 Overview: Connecting to an SQL or ODBC data source=H_CONNECTING_TO_AN_SQL_OR_ODBC_DATA_SOURCE_OVER@la1n50en.hlp>Overview 4 Installing an ODBC driver=H_INSTALLING_AN_ODBC_DRIVER_STEPS@la1n50en.hlp>Steps 4 Selecting tables for an SQL SELECT statement=H_SELECTING_TABLES_IN_THE_TABLES_TAB_STEPS@la1n50en.hlp>Steps 4 Creating joins for an SQL SELECT statement=H_CREATING_JOINS_IN_THE_JOIN_TAB_STEPS@la1n50en.hlp>Steps 4 Creating find conditions for an SQL SELECT statement=H_CREATING_FIND_CONDITIONS_IN_THE_CONDITION_TAB_STEPS@la1n50en.hlp>Steps 4 Selecting fields for an SQL SELECT statement=H_SELECTING_FIELDS_IN_THE_FIELDS_TAB_STEPS@la1n50en.hlp>Steps 4 Sorting fields for an SQL SELECT statement=H_SORTING_FIELDS_IN_THE_SORT_TAB_STEPS@la1n50en.hlp>Steps 4 Editing SQL statements=H_EDITING_SQL_STATEMENTS_IN_THE_SQL_TAB_STEPS@la1n50en.hlp>Steps 2 Define Fields for a Database 3 Add, Edit, and Delete Database Fields 4 Overview: Types of fields=H_TYPES_OF_FIELDS_OVER@la1n50en.hlp>Overview 4 Adding fields to a database=H_ADDING_FIELDS_TO_A_DATABASE_STEPS@la1n50en.hlp>Steps 4 Writing formulas for calculated fields=H_WRITING_FORMULAS_FOR_CALCULATED_FIELDS_STEPS@la1n50en.hlp>Steps 4 Calculating a summary across records=H_CALCULATING_A_SUMMARY_ACROSS_RECORDS_STEPS@la1n50en.hlp>Steps 4 Editing fields of a database=H_EDITING_FIELDS_OF_A_DATABASE_STEPS@la1n50en.hlp>Steps 4 Specifying a key field for a Paradox database=H_SPECIFYING_A_KEY_FIELD_FOR_A_PARADOX_DATABASE_STEPS@la1n50en.hlp>Steps 4 Deleting fields from a database=H_DELETING_FIELDS_FROM_A_DATABASE_STEPS@la1n50en.hlp>Steps 3 Customize Fields for Data Entry 4 Entering data automatically=H_ENTERING_DATA_AUTOMATICALLY_STEPS@la1n50en.hlp>Steps 4 Verifying the accuracy of entered data=H_VERIFYING_THE_ACCURACY_OF_ENTERED_DATA_STEPS@la1n50en.hlp>Steps 4 Setting OLE options for PicturePlus fields=H_SETTING_OLE_OPTIONS_FOR_PICTUREPLUS_FIELDS_STEPS@la1n50en.hlp>Steps 4 Setting data options for a variable field=H_SETTING_DATA_OPTIONS_FOR_A_VARIABLE_FIELD_STEPS@la1n50en.hlp>Steps 2 Add and Edit Fields in Views 3 Display Fields in a View 4 Overview: Fields=H_FIELDS_OVER@la1n50en.hlp>Overview 4 Adding fields to a view=H_ADDING_FIELDS_TO_A_VIEW_STEPS@la1n50en.hlp>Steps 4 Displaying fields as scrolling lists=H_DISPLAYING_FIELDS_AS_SCROLLING_LISTS_STEPS@la1n50en.hlp>Steps 4 Displaying fewer values in a scrolling list=H_DISPLAYING_FEWER_VALUES_IN_A_SCROLLING_LIST_STEPS@la1n50en.hlp>Steps 4 Displaying descriptive values in a scrolling list=H_DISPLAYING_DESCRIPTIVE_VALUES_IN_A_SCROLLING_LIST_STEPS@la1n50en.hlp>Steps 4 Adding and deleting items in scrolling lists=H_ADDING_AND_DELETING_ITEMS_IN_SCROLLING_LISTS_STEPS@la1n50en.hlp>Steps 4 Displaying fields as check boxes=H_DISPLAYING_FIELDS_AS_CHECK_BOXES_STEPS@la1n50en.hlp>Steps 4 Displaying fields as radio buttons=H_DISPLAYING_FIELDS_AS_RADIO_BUTTONS_STEPS@la1n50en.hlp>Steps 4 Rearranging a set of radio buttons or check boxes=H_REARRANGING_A_SET_OF_RADIO_BUTTONS_OR_CHECK_BOXES_STEPS@la1n50en.hlp>Steps 3 Format Data in Fields 4 Formatting dates=H_FORMATTING_DATES_STEPS@la1n50en.hlp>Steps 4 Formatting dates as quarters, thirds, and so on=H_FORMATTING_DATES_AS_QUARTERS_THIRDS_AND_SO_ON_STEPS@la1n50en.hlp>Steps 4 Formatting times=H_FORMATTING_TIMES_STEPS@la1n50en.hlp>Steps 4 Formatting numbers=H_FORMATTING_NUMBERS_STEPS@la1n50en.hlp>Steps 4 Formatting data in text fields=H_SETTING_A_FORMAT_FOR_DATA_IN_TEXT_FIELDS_STEPS@la1n50en.hlp>Steps 3 Edit Fields and Their Labels 4 Changing text attributes of labels or data=H_CHANGING_TEXT_ATTRIBUTES_OF_LABELS_OR_DATA_STEPS@la1n50en.hlp>Steps 4 Editing labels=H_EDITING_LABELS_STEPS@la1n50en.hlp>Steps 4 Changing the position of labels=H_CHANGING_THE_POSITION_OF_LABELS_STEPS@la1n50en.hlp>Steps 4 Hiding labels=H_HIDING_LABELS_STEPS@la1n50en.hlp>Steps 4 Closing up extra space between fields=H_CLOSING_EXTRA_SPACE_BETWEEN_FIELDS_STEPS@la1n50en.hlp>Steps 4 Changing the tab order on views=H_CHANGING_THE_TAB_ORDER_ON_VIEWS_STEPS@la1n50en.hlp>Steps 4 Removing fields from the tab order=H_REMOVING_OBJECTS_AND_FIELDS_FROM_THE_TAB_ORDER_STEPS@la1n50en.hlp>Steps 3 Work with PicturePlus Fields 4 Adding PicturePlus fields to a view=H_ADDING_PICTUREPLUS_FIELDS_TO_A_VIEW_STEPS@la1n50en.hlp>Steps 4 Setting OLE options for PicturePlus fields=H_SETTING_OLE_OPTIONS_FOR_PICTUREPLUS_FIELDS_STEPS@la1n50en.hlp>Steps 4 Pasting pictures in fields=H_PASTING_PICTURES_IN_FIELDS_STEPS@la1n50en.hlp>Steps 4 Editing pictures in PicturePlus fields=H_EDITING_PICTURES_IN_PICTUREPLUS_FIELDS_STEPS@la1n50en.hlp>Steps 4 Drawing in PicturePlus fields=H_DRAWING_IN_PICTUREPLUS_FIELDS_STEPS@la1n50en.hlp>Steps 4 Changing display options for a PicturePlus field=H_CHANGING_DISPLAY_OPTIONS_FOR_A_PICTUREPLUS_FIELD_STEPS@la1n50en.hlp>Steps 4 Copying PicturePlus pictures to a file=H_COPYING_PICTUREPLUS_PICTURES_TO_A_FILE_STEPS@la1n50en.hlp>Steps 2 Join Databases 3 Joining database files=H_JOINING_DATABASE_FILES_STEPS@la1n50en.hlp>Steps 3 Setting options for a join=H_SETTING_OPTIONS_FOR_A_JOIN_STEPS@la1n50en.hlp>Steps 4 Making calculated fields available for joins=H_MAKING_CALCULATED_FIELDS_AVAILABLE_FOR_JOINS_STEPS@la1n50en.hlp>Steps 3 Unjoining database files=H_UNJOINING_DATABASE_FILES_STEPS@la1n50en.hlp>Steps 3 Overview: Joined databases=H_JOINED_DATABASES_OVER@la1n50en.hlp>Overview 3 Overview: Main and detail databases in a view=H_MAIN_AND_DETAIL_DATABASES_IN_A_VIEW_OVER@la1n50en.hlp>Overview 3 Overview: One-to-many, many-to-one, and one-to-one relationships=H_ONE_TO_MANY_MANY_TO_ONE_AND_ONE_TO_ONE_RELATIONSHIPS_OVER@la1n50en.hlp>Overview 3 Overview: Many-to-many relationships=H_MANY_TO_MANY_RELATIONSHIPS_OVER@la1n50en.hlp>Overview 3 Overview: Alias joins=H_ALIAS_JOINS_OVER@la1n50en.hlp>Overview 3 Joining a database to itself (alias join)=H_JOINING_A_DATABASE_TO_ITSELF_STEPS@la1n50en.hlp>Steps 2 Work in Design 3 Overview: InfoBox=H_INFOBOX_OVER@la1n50en.hlp>Overview 3 Customize the Design Environment 4 Showing the grid to help you design views=H_SHOWING_THE_GRID_TO_HELP_YOU_DESIGN_VIEWS_STEPS@la1n50en.hlp>Steps 4 Snapping objects to the grid=H_SNAPPING_OBJECTS_TO_THE_GRID_STEPS@la1n50en.hlp>Steps 4 Showing rulers=H_SHOWING_RULERS_STEPS@la1n50en.hlp>Steps 4 Showing the Tools palette=H_SHOWING_THE_TOOLS_PALETTE_STEPS@la1n50en.hlp>Steps 4 Showing the Internet Tools palette=H_SHOWING_THE_INTERNET_TOOLS_PALETTE_STEPS@la1n50en.hlp>Steps 4 Showing data or field names=H_SHOWING_DATA_OR_FIELD_NAMES_STEPS@la1n50en.hlp>Steps 4 Zooming in and out=H_ZOOMING_IN_AND_OUT_STEPS@la1n50en.hlp>Steps 3 Work with Named Styles 4 Overview: Working with named styles=H_WORKING_WITH_NAMED_STYLES_OVER@la1n50en.hlp>Overview 4 Defining new named styles=H_DEFINING_NEW_NAMED_STYLES_STEPS@la1n50en.hlp>Steps 4 Defining a named style based on an existing object's properties=H_DEFINING_A_NAMED_STYLE_BASED_ON_AN_EXISTING_OBJECTS_PROPERTIES_STEPS@la1n50en.hlp>Steps 4 Redefining named styles=H_REDEFINING_NAMED_STYLES_STEPS@la1n50en.hlp>Steps 4 Applying named styles=H_APPLYING_NAMED_STYLES_STEPS@la1n50en.hlp>Steps 4 Managing named styles=H_MANAGING_NAMED_STYLES_STEPS@la1n50en.hlp>Steps 4 Copying named styles=H_COPYING_NAMED_STYLES_STEPS@la1n50en.hlp>Steps 4 Editing named styles=H_EDITING_NAMED_STYLES_STEPS@la1n50en.hlp>Steps 4 Deleting named styles=H_DELETING_NAMED_STYLES_STEPS@la1n50en.hlp>Steps 3 Add Objects to the Background of a View 4 Drawing geometric objects=H_DRAWING_GEOMETRIC_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Adding text blocks=H_ADDING_TEXT_BLOCKS_STEPS@la1n50en.hlp>Steps 4 Adding multiple objects to a view=H_ADDING_MULTIPLE_OBJECTS_TO_A_VIEW_STEPS@la1n50en.hlp>Steps 4 Pasting pictures in views=H_PASTING_PICTURES_IN_VIEWS_STEPS@la1n50en.hlp>Steps 4 Inserting dates or times=H_INSERTING_DATES_OR_TIMES_STEPS@la1n50en.hlp>Steps 4 Adding buttons to run macros=H_ADDING_MACRO_BUTTONS_STEPS@la1n50en.hlp>Steps 3 Change Objects and Text 4 Applying properties from another object (Fast Format)=H_APPLYING_PROPERTIES_FROM_ANOTHER_OBJECT_STEPS@la1n50en.hlp>Steps 4 Selecting objects=H_SELECTING_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Resizing objects=H_RESIZING_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Moving objects=H_MOVING_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Selecting text in text blocks=H_SELECTING_TEXT_IN_A_TEXT_BLOCK_STEPS@la1n50en.hlp>Steps 4 Cutting or copying objects or text=H_CUTTING_OR_COPYING_OBJECTS_OR_TEXT_STEPS@la1n50en.hlp>Steps 4 Changing the width of lines or borders=H_CHANGING_THE_WIDTH_OF_LINES_OR_BORDERS_STEPS@la1n50en.hlp>Steps 4 Creating partial borders=H_CREATING_PARTIAL_BORDERS_STEPS@la1n50en.hlp>Steps 4 Making objects and views transparent=H_MAKING_OBJECTS_AND_VIEWS_TRANSPARENT_STEPS@la1n50en.hlp>Steps 4 Putting objects and fields in the tab order=H_PUTTING_OBJECTS_AND_FIELDS_IN_THE_TAB_ORDER_STEPS@la1n50en.hlp>Steps 4 Changing the tab order on views=H_CHANGING_THE_TAB_ORDER_ON_VIEWS_STEPS@la1n50en.hlp>Steps 3 Work with More Than One Object at a Time 4 Grouping and ungrouping objects=H_GROUPING_AND_UNGROUPING_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Changing the order of overlapping objects=H_CHANGING_THE_ORDER_OF_OVERLAPPING_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Aligning and distributing objects=H_ALIGNING_AND_DISTRIBUTING_OBJECTS_STEPS@la1n50en.hlp>Steps 3 Edit Views 4 Naming views=H_NAMING_VIEWS_AND_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Selecting a main database for a view=H_SELECTING_A_MAIN_DATABASE_FOR_A_VIEW_STEPS@la1n50en.hlp>Steps 4 Changing the menu for a view=H_CHANGING_THE_MENU_FOR_A_VIEW_STEPS@la1n50en.hlp>Steps 4 Hiding views=H_HIDING_VIEWS_STEPS@la1n50en.hlp>Steps 4 Redisplaying hidden views=H_REDISPLAYING_HIDDEN_VIEWS_STEPS@la1n50en.hlp>Steps 4 Showing more of the view by hiding its margins=H_SHOWING_MORE_OF_THE_VIEW_BY_HIDING_ITS_MARGINS_STEPS@la1n50en.hlp>Steps 4 Changing the width of the view border=H_CHANGING_THE_WIDTH_OF_LINES_OR_BORDERS_STEPS@la1n50en.hlp>Steps 4 Creating partial borders for views=H_CREATING_PARTIAL_BORDERS_STEPS@la1n50en.hlp>Steps 4 Duplicating views=H_DUPLICATING_VIEWS_STEPS@la1n50en.hlp>Steps 4 Deleting views=H_DELETING_VIEWS_STEPS@la1n50en.hlp>Steps 4 Deleting elements of a view=H_DELETING_ELEMENTS_OF_A_VIEW_STEPS@la1n50en.hlp>Steps 4 Adding fields to a view=H_ADDING_FIELDS_TO_A_VIEW_STEPS@la1n50en.hlp>Steps 2 Preview and Print 3 Overview: Printing Approach views=H_PRINTING_APPROACH_VIEWS_OVER@la1n50en.hlp>Overview 3 Downloading data before previewing=H_DOWNLOADING_DATA_BEFORE_PREVIEWING_STEPS@la1n50en.hlp>Steps 3 Previewing views=H_PREVIEWING_VIEWS_STEPS@la1n50en.hlp>Steps 3 Printing views=H_PRINTING_VIEWS_STEPS@la1n50en.hlp>Steps 3 Formatting worksheets or crosstabs for printing=H_FORMATTING_WORKSHEETS_OR_CROSSTABS_FOR_PRINTING_STEPS@la1n50en.hlp>Steps 3 Reducing or expanding sections of reports when printing=H_PRINTING_REPORTS_STEPS@la1n50en.hlp>Steps 3 Closing up extra space between fields=H_CLOSING_EXTRA_SPACE_BETWEEN_FIELDS_STEPS@la1n50en.hlp>Steps 3 Setting objects and fields to slide when printing=H_SETTING_OBJECTS_AND_FIELDS_TO_SLIDE_WHEN_PRINTING_STEPS@la1n50en.hlp>Steps 3 Preventing objects and fields from printing=H_PREVENTING_OBJECTS_AND_FIELDS_FROM_PRINTING_STEPS@la1n50en.hlp>Steps 3 Properties of printers=H_PROPERTIES_OF_PRINTERS_REF@la1n50en.hlp>Overview 3 Specifying the printer, paper, and orientation=H_SPECIFYING_THE_PRINTER_PAPER_AND_ORIENTATION_STEPS@la1n50en.hlp>Steps 3 Printing a list of file properties=H_APPROACH_FILE_PROPERTIES_REF@la1n50en.hlp>Overview 3 Printing a list of database fields=H_PRINTING_A_LIST_OF_DATABASE_FIELDS_STEPS@la1n50en.hlp>Steps 3 Printing a diagram of join relationships=H_PRINTING_A_DIAGRAM_OF_JOIN_RELATIONSHIPS_STEPS@la1n50en.hlp>Steps 3 Printing macros=H_PRINTING_MACRO_COMMANDS_STEPS@la1n50en.hlp>Steps 2 Design Forms and Repeating Panels 3 Create Forms 4 Overview: Forms=H_FORMS_OVER@la1n50en.hlp>Overview 4 Deciding what new forms look like=H_DECIDING_WHAT_NEW_FORMS_LOOK_LIKE_REF@la1n50en.hlp>Overview 4 Adding fields to new forms=H_ADDING_FIELDS_TO_NEW_FORMS_STEPS@la1n50en.hlp>Steps 4 Removing or reordering fields while creating new views=H_REMOVING_OR_REORDERING_FIELDS_WHILE_CREATING_NEW_VIEWS_STEPS@la1n50en.hlp>Steps 4 Creating new forms that include a repeating panel=H_ADDING_A_REPEATING_PANEL_TO_NEW_FORMS_STEPS@la1n50en.hlp>Steps 4 Adding pages to forms=H_ADDING_PAGES_TO_FORMS_STEPS@la1n50en.hlp>Steps 3 Create Repeating Panels 4 Overview: Repeating panels=H_REPEATING_PANELS_OVER@la1n50en.hlp>Overview 4 Creating new forms that include a repeating panel=H_ADDING_A_REPEATING_PANEL_TO_NEW_FORMS_STEPS@la1n50en.hlp>Steps 4 Adding a repeating panel to existing forms=H_ADDING_A_REPEATING_PANEL_TO_EXISTING_FORMS_STEPS@la1n50en.hlp>Steps 4 Summarizing data for records in repeating panels=H_SUMMARIZING_DATA_FOR_RECORDS_IN_REPEATING_PANELS_STEPS@la1n50en.hlp>Steps 4 Adding fields to repeating panels=H_ADDING_FIELDS_TO_REPEATING_PANELS_STEPS@la1n50en.hlp>Steps 4 Selecting repeating panels=H_SELECTING_REPEATING_PANELS_STEPS@la1n50en.hlp>Steps 4 Setting a default sort order for a repeating panel=H_SORTING_RECORDS_IN_REPEATING_PANELS_STEPS@la1n50en.hlp>Steps 4 Naming repeating panels=H_NAMING_VIEWS_AND_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Design Repeating Panels 5 Hiding labels in repeating panels=H_HIDING_LABELS_IN_REPEATING_PANELS_STEPS@la1n50en.hlp>Steps 5 Rearranging fields in repeating panels=H_REARRANGING_FIELDS_IN_REPEATING_PANELS_STEPS@la1n50en.hlp>Steps 5 Resizing repeating panels=H_RESIZING_REPEATING_PANELS_STEPS@la1n50en.hlp>Steps 5 Alternating the color of records in a repeating panel=H_ALTERNATING_THE_COLOR_OF_RECORDS_IN_A_REPEATING_PANEL_STEPS@la1n50en.hlp>Steps 5 Changing the width of borders for repeating panels=H_CHANGING_THE_WIDTH_OF_LINES_OR_BORDERS_STEPS@la1n50en.hlp>Steps 5 Creating partial borders around repeating panels=H_CREATING_PARTIAL_BORDERS_STEPS@la1n50en.hlp>Steps 5 Creating a shadow behind repeating panels=H_CREATING_A_SHADOW_STEPS@la1n50en.hlp>Steps 2 Design Worksheets 3 Creating new worksheets=H_CREATING_NEW_WORKSHEETS_STEPS@la1n50en.hlp>Steps 3 Selecting in worksheets or crosstabs=H_SELECTING_IN_WORKSHEETS_OR_CROSSTABS_REF@la1n50en.hlp>Overview 3 Copying selections to the Clipboard=H_COPYING_SELECTIONS_TO_THE_CLIPBOARD_STEPS@la1n50en.hlp>Steps 3 Dividing worksheets and crosstabs into panes=H_DIVIDING_WORKSHEETS_AND_CROSSTABS_INTO_PANES_STEPS@la1n50en.hlp>Steps 3 Formatting worksheets or crosstabs for printing=H_FORMATTING_WORKSHEETS_OR_CROSSTABS_FOR_PRINTING_STEPS@la1n50en.hlp>Steps 3 Removing fields from worksheets or crosstabs=H_REMOVING_FIELDS_FROM_WORKSHEETS_OR_CROSSTABS_STEPS@la1n50en.hlp>Steps 3 Moving columns in worksheets or crosstabs=H_MOVING_COLUMNS_IN_WORKSHEETS_OR_CROSSTABS_STEPS@la1n50en.hlp>Steps 3 Resizing columns and rows in worksheets or crosstabs =H_RESIZING_COLUMNS_AND_ROWS_IN_WORKSHEETS_OR_CROSSTABS_STEPS@la1n50en.hlp>Steps 3 Adding formula columns to worksheets=H_ADDING_FORMULA_COLUMNS_TO_WORKSHEETS_STEPS@la1n50en.hlp>Steps 3 Adding blank columns to worksheets=H_ADDING_BLANK_COLUMNS_TO_WORKSHEETS_STEPS@la1n50en.hlp>Steps 3 Editing column header text=H_EDITING_COLUMN_HEADER_TEXT_STEPS@la1n50en.hlp>Steps 2 Design Reports 3 Overview: Reports=H_REPORTS_OVER@la1n50en.hlp>Overview 3 Overview: Report panels=H_REPORT_PANELS_OVER@la1n50en.hlp>Overview 3 Use PowerClick Reporting 4 Creating a PowerClick report with a grand total=H_CREATING_A_POWERCLICK_REPORT_WITH_A_GRAND_TOTAL_STEPS@la1n50en.hlp>Steps 4 Creating a PowerClick report with subtotals for groups=H_CREATING_A_POWERCLICK_REPORT_WITH_SUBTOTALS_FOR_GROUPS_STEPS@la1n50en.hlp>Steps 4 Grouping records in reports=H_GROUPING_RECORDS_IN_REPORTS_STEPS@la1n50en.hlp>Steps 4 Adding summaries to reports=H_ADDING_SUMMARIES_TO_REPORTS_STEPS@la1n50en.hlp>Steps 3 Create Reports 4 Deciding what new reports look like=H_DECIDING_WHAT_NEW_REPORTS_LOOK_LIKE_REF@la1n50en.hlp>Overview 4 Adding fields to new reports=H_ADDING_FIELDS_TO_NEW_REPORTS_STEPS@la1n50en.hlp>Steps 4 Grouping records in new reports=H_GROUPING_RECORDS_IN_NEW_REPORTS_STEPS@la1n50en.hlp>Steps 4 Adding repeating fields to new repeating panel reports=H_ADDING_REPEATING_FIELDS_TO_NEW_REPEATING_PANEL_REPORTS_STEPS@la1n50en.hlp>Steps 4 Adding summaries to new reports=H_ADDING_SUMMARIES_TO_NEW_REPORTS_STEPS@la1n50en.hlp>Steps 3 Summarize Data in Reports 4 Adding summaries to reports=H_ADDING_SUMMARIES_TO_REPORTS_STEPS@la1n50en.hlp>Steps 4 Summary calculations=H_SUMMARY_CALCULATIONS_REF@la1n50en.hlp>Overview 4 Choosing which records go into a summary=H_CHOOSING_WHICH_RECORDS_GO_INTO_A_SUMMARY_STEPS@la1n50en.hlp>Steps 4 Moving summaries=H_MOVING_SUMMARIES_STEPS@la1n50en.hlp>Steps 3 Revise Reports 4 Adding fields to reports=H_ADDING_FIELDS_TO_REPORTS_STEPS@la1n50en.hlp>Steps 4 Creating charts in reports=H_CREATING_CHARTS_IN_REPORTS_STEPS@la1n50en.hlp>Steps 4 Selecting, moving, and deleting report panels=H_SELECTING_MOVING_AND_DELETING_REPORT_PANELS_STEPS@la1n50en.hlp>Steps 4 Grouping records in reports=H_GROUPING_RECORDS_IN_REPORTS_STEPS@la1n50en.hlp>Steps 4 Changing the number of columns in reports=H_CHANGING_THE_NUMBER_OF_COLUMNS_IN_REPORTS_STEPS@la1n50en.hlp>Steps 4 Moving and resizing report columns=H_MOVING_AND_RESIZING_REPORT_COLUMNS_STEPS@la1n50en.hlp>Steps 4 Showing missing records in a report=H_SHOWING_ALL_GROUPS_IN_A_REPORT_STEPS@la1n50en.hlp>Steps 3 Print Reports 4 Reducing or expanding sections of reports when printing=H_PRINTING_REPORTS_STEPS@la1n50en.hlp>Steps 4 Creating title pages for reports=H_CREATING_TITLE_PAGES_FOR_REPORTS_STEPS@la1n50en.hlp>Steps 4 Adding dates, times, or page numbers to reports=H_ADDING_DATES_TIMES_OR_PAGE_NUMBERS_TO_REPORTS_STEPS@la1n50en.hlp>Steps 4 Changing the number of columns in reports=H_CHANGING_THE_NUMBER_OF_COLUMNS_IN_REPORTS_STEPS@la1n50en.hlp>Steps 4 Paginating reports=H_PAGINATING_REPORTS_STEPS@la1n50en.hlp>Steps 2 Design Form Letters 3 Overview: Form letters=H_FORM_LETTERS_OVER@la1n50en.hlp>Overview 3 Create Form Letters 4 Deciding what new form letters look like=H_DECIDING_WHAT_NEW_FORM_LETTERS_LOOK_LIKE_REF@la1n50en.hlp>Overview 4 Adding the return address to form letters=H_ADDING_THE_RETURN_ADDRESS_TO_FORM_LETTERS_STEPS@la1n50en.hlp>Steps 4 Adding the recipient address to form letters=H_ADDING_THE_RECIPIENT_ADDRESS_TO_FORM_LETTERS_STEPS@la1n50en.hlp>Steps 4 Adding the salutation to form letters=H_ADDING_THE_SALUTATION_TO_FORM_LETTERS_STEPS@la1n50en.hlp>Steps 4 Adding the close to form letters=H_ADDING_THE_CLOSE_TO_FORM_LETTERS_STEPS@la1n50en.hlp>Steps 4 Adding envelopes to form letters=H_ADDING_ENVELOPES_TO_FORM_LETTERS_STEPS@la1n50en.hlp>Steps 3 Revise Form Letters 4 Entering text in form letters=H_ENTERING_TEXT_IN_FORM_LETTERS_STEPS@la1n50en.hlp>Steps 4 Adding fields to form letters=H_ADDING_FIELDS_TO_FORM_LETTERS_STEPS@la1n50en.hlp>Steps 4 Changing the date format on form letters=H_CHANGING_THE_DATE_FORMAT_ON_FORM_LETTERS_STEPS@la1n50en.hlp>Steps 4 Moving or deleting form letter fields=H_MOVING_OR_DELETING_FORM_LETTER_FIELDS_STEPS@la1n50en.hlp>Steps 2 Design Envelopes and Mailing Labels 3 Overview: Envelopes=H_ENVELOPES_OVER@la1n50en.hlp>Overview 3 Overview: Mailing labels=H_MAILING_LABELS_OVER@la1n50en.hlp>Overview 3 Create Envelopes 4 Deciding what new envelopes look like=H_DECIDING_WHAT_NEW_ENVELOPES_LOOK_LIKE_REF@la1n50en.hlp>Overview 4 Adding the return address to envelopes=H_ADDING_THE_RETURN_ADDRESS_TO_ENVELOPES_STEPS@la1n50en.hlp>Steps 4 Adding the recipient address to envelopes=H_ADDING_THE_RECIPIENT_ADDRESS_TO_ENVELOPES_STEPS@la1n50en.hlp>Steps 4 Selecting print settings for envelopes=H_SELECTING_PRINT_SETTINGS_FOR_ENVELOPES_STEPS@la1n50en.hlp>Steps 3 Create Mailing Labels 4 Creating mailing labels=H_CREATING_MAILING_LABELS_STEPS@la1n50en.hlp>Steps 4 Creating custom mailing label types=H_CREATING_CUSTOM_MAILING_LABEL_TYPES_STEPS@la1n50en.hlp>Steps 4 Adding text to mailing labels=H_ADDING_TEXT_TO_MAILING_LABELS_STEPS@la1n50en.hlp>Steps 4 Moving or resizing mailing label fields=H_MOVING_OR_RESIZING_MAILING_LABEL_FIELDS_STEPS@la1n50en.hlp>Steps 4 Closing up extra space between fields=H_CLOSING_EXTRA_SPACE_BETWEEN_FIELDS_STEPS@la1n50en.hlp>Steps 4 Changing or deleting custom mailing label types=H_CHANGING_OR_DELETING_CUSTOM_MAILING_LABEL_TYPES_STEPS@la1n50en.hlp>Steps 2 Design Crosstabs 3 Overview: Crosstabs=H_CROSSTABS_OVER@la1n50en.hlp>Overview 3 Adding rows to new crosstabs=H_ADDING_ROWS_TO_NEW_CROSSTABS_STEPS@la1n50en.hlp>Steps 3 Adding columns to new crosstabs=H_ADDING_COLUMNS_TO_NEW_CROSSTABS_STEPS@la1n50en.hlp>Steps 3 Adding values to new crosstabs=H_ADDING_VALUES_TO_NEW_CROSSTABS_STEPS@la1n50en.hlp>Steps 3 Adding summaries to crosstabs=H_ADDING_SUMMARIES_TO_CROSSTABS_STEPS@la1n50en.hlp>Steps 3 Editing crosstab summaries=H_EDITING_CROSSTAB_SUMMARIES_STEPS@la1n50en.hlp>Steps 3 Adding or moving fields in crosstabs=H_ADDING_OR_MOVING_FIELDS_IN_CROSSTABS_STEPS@la1n50en.hlp>Steps 3 Applying found sets to crosstabs=H_APPLYING_FOUND_SETS_TO_CROSSTABS_STEPS@la1n50en.hlp>Steps 3 Adding all groups to crosstabs=H_ADDING_ALL_GROUPS_TO_CROSSTABS_STEPS@la1n50en.hlp>Steps 3 Selecting rows and columns in crosstabs=H_SELECTING_ROWS_AND_COLUMNS_IN_CROSSTABS_STEPS@la1n50en.hlp>Steps 3 Creating charts from crosstabs=H_CREATING_CHARTS_FROM_CROSSTABS_STEPS@la1n50en.hlp>Steps 3 Overview: Drill down to data=H_DRILL_DOWN_TO_DATA_OVER@la1n50en.hlp>Overview 3 Finding records that make up crosstabs (drill down to data)=H_FINDING_RECORDS_THAT_MAKE_UP_CROSSTABS_STEPS@la1n50en.hlp>Steps 3 Selecting drill-down views=H_CHOOSING_DRILLDOWN_VIEWS_STEPS@la1n50en.hlp>Steps 2 Design Charts 3 Create Charts Using the Chart Assistant 4 Overview: Chart Assistant=H_CHART_ASSISTANT_OVER@la1n50en.hlp>Overview 4 Deciding what new charts look like=H_DECIDING_WHAT_NEW_CHARTS_LOOK_LIKE_REF@la1n50en.hlp>Overview 4 Selecting a field for the x-axis=H_SELECTING_A_FIELD_FOR_THE_X_AXIS_STEPS@la1n50en.hlp>Steps 4 Selecting fields for the y-axis=H_SELECTING_FIELDS_FOR_THE_Y_AXIS_STEPS@la1n50en.hlp>Steps 4 Selecting a field for the series (chart legend)=H_SELECTING_A_FIELD_FOR_THE_SERIES_STEPS@la1n50en.hlp>Steps 4 Creating pie charts=H_CREATING_PIE_CHARTS_STEPS@la1n50en.hlp>Steps 3 Revise Charts 4 Drill-down to data for charts=H_DRILL_DOWN_TO_DATA_FOR_CHARTS_STEPS@la1n50en.hlp>Steps 4 Charting a different data set=H_CHARTING_A_DIFFERENT_DATA_SET_STEPS@la1n50en.hlp>Steps 3 Create Charts in Reports and Crosstabs 4 Creating charts in reports=H_CREATING_CHARTS_IN_REPORTS_STEPS@la1n50en.hlp>Steps 4 Creating charts from crosstabs=H_CREATING_CHARTS_FROM_CROSSTABS_STEPS@la1n50en.hlp>Steps :include LC1N21EN.CNT 2 Enter and Edit Data 3 Add, Delete, and Hide Records 4 Adding new records=H_ADDING_NEW_RECORDS_STEPS@la1n50en.hlp>Steps 4 Duplicating records=H_DUPLICATING_RECORDS_STEPS@la1n50en.hlp>Steps 4 Deleting specific records=H_DELETING_SPECIFIC_RECORDS_STEPS@la1n50en.hlp>Steps 4 Deleting a found set of records=H_DELETING_A_FOUND_SET_OF_RECORDS_STEPS@la1n50en.hlp>Steps 4 Deleting all records=H_DELETING_ALL_RECORDS_STEPS@la1n50en.hlp>Steps 4 Hiding records=H_HIDING_RECORDS_STEPS@la1n50en.hlp>Steps 4 Showing hidden records=H_SHOWING_HIDDEN_RECORDS_STEPS@la1n50en.hlp>Steps 3 Enter Data in Fields 4 Selecting fields=H_SELECTING_FIELDS_STEPS@la1n50en.hlp>Steps 4 Entering text in text or memo fields=H_ENTERING_TEXT_IN_TEXT_OR_MEMO_FIELDS_STEPS@la1n50en.hlp>Steps 4 Entering values in numeric fields=H_ENTERING_VALUES_IN_NUMERIC_FIELDS_STEPS@la1n50en.hlp>Steps 4 Entering values in Boolean fields=H_ENTERING_VALUES_IN_BOOLEAN_FIELDS_STEPS@la1n50en.hlp>Steps 4 Entering dates in date fields=H_ENTERING_DATES_IN_DATE_FIELDS_STEPS@la1n50en.hlp>Steps 4 Entering times in time fields=H_ENTERING_TIMES_IN_TIME_FIELDS_STEPS@la1n50en.hlp>Steps 4 Duplicating a value from the last record modified=H_DUPLICATING_VALUES_FROM_THE_LAST_RECORD_MODIFIED_STEPS@la1n50en.hlp>Steps 4 Selecting from a drop-down box=H_SELECTING_FROM_A_DROPDOWN_BOX_STEPS@la1n50en.hlp>Steps 4 Selecting radio buttons or check boxes=H_SELECTING_RADIO_BUTTONS_OR_CHECK_BOXES_STEPS@la1n50en.hlp>Steps 4 Entering the same data into many records=H_ENTERING_THE_SAME_DATA_INTO_MANY_RECORDS_STEPS@la1n50en.hlp>Steps 4 Pasting pictures in fields=H_PASTING_PICTURES_IN_FIELDS_STEPS@la1n50en.hlp>Steps 4 Drawing in PicturePlus fields=H_DRAWING_IN_PICTUREPLUS_FIELDS_STEPS@la1n50en.hlp>Steps 3 Move to Another Record 4 Moving through records one record at a time=H_MOVING_ONE_RECORD_AT_A_TIME_STEPS@la1n50en.hlp>Steps 4 Moving to the first or last record=H_MOVING_TO_THE_FIRST_OR_LAST_RECORD_STEPS@la1n50en.hlp>Steps 4 Moving to a specific record=H_MOVING_TO_A_SPECIFIC_RECORD_STEPS@la1n50en.hlp>Steps 3 Check Spelling 4 Checking spelling=H_RUNNING_THE_SPELLING_CHECKER_STEPS@la1n50en.hlp>Steps 4 Editing the user dictionary=H_EDITING_THE_USER_DICTIONARY_STEPS@la1n50en.hlp>Steps 4 Changing to another main dictionary=H_CHANGING_TO_ANOTHER_MAIN_DICTIONARY_STEPS@la1n50en.hlp>Steps 4 Setting options for checking spelling=H_SETTING_OPTIONS_FOR_CHECKING_SPELLING_STEPS@la1n50en.hlp>Steps 3 Find and Replace Text 4 Finding text=H_FINDING_TEXT_STEPS@la1n50en.hlp>Steps 4 Replacing text=H_REPLACING_TEXT_STEPS@la1n50en.hlp>Steps 2 Find Records 3 Overview: The found set=H_THE_FOUND_SET_OVER@la1n50en.hlp>Overview 3 Showing all records=H_SHOWING_ALL_RECORDS_STEPS@la1n50en.hlp>Steps 3 Find Records Using the Find Assistant 4 Overview: Finding records with the Find Assistant=H_FINDING_RECORDS_WITH_THE_FIND_ASSISTANT_OVER@la1n50en.hlp>Overview 4 Selecting a find type with the Find Assistant=H_SELECTING_A_FIND_TYPE_WITH_THE_FIND_ASSISTANT_REF@la1n50en.hlp>Overview 4 Creating a find condition with the Find Assistant=H_CREATING_A_FIND_CONDITION_WITH_THE_FIND_ASSISTANT_STEPS@la1n50en.hlp>Steps 4 Finding duplicate records with the Find Assistant=H_FINDING_DUPLICATE_RECORDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n50en.hlp>Steps 4 Finding distinct records with the Find Assistant=H_FINDING_DISTINCT_OR_UNIQUE_RECORDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n50en.hlp>Steps 4 Finding the top or lowest values with the Find Assistant=H_FINDING_THE_TOP_OR_LOWEST_VALUES_WITH_THE_FIND_ASSISTANT_STEPS@la1n50en.hlp>Steps 4 Sorting fields with the Find Assistant=H_SORTING_FIELDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n50en.hlp>Steps 3 Find Records Using Query by Box 4 Finding records using Query by Box=H_FINDING_RECORDS_USING_QUERY_BY_BOX_STEPS@la1n50en.hlp>Steps 4 Overview: Defining find conditions graphically in Query by Box=H_DEFINING_FIND_CONDITIONS_GRAPHICALLY_IN_QUERY_BY_BOX_OVER@la1n50en.hlp>Overview 4 Overview: Multiple find conditions in Query by Box=H_MULTIPLE_FIND_CONDITIONS_IN_QUERY_BY_BOX_OVER@la1n50en.hlp>Overview 3 Find Records Using a Blank View 4 Creating find requests=H_CREATING_FIND_REQUESTS_STEPS@la1n50en.hlp>Steps 4 Finding records that satisfy multiple conditions (AND)=H_FINDING_RECORDS_THAT_SATISFY_MULTIPLE_CONDITIONS_(AND)_STEPS@la1n50en.hlp>Steps 4 Finding records that satisfy at least one of several conditions (OR)=H_FIND_RECORDS_TO_SATISFY_ONE_OF_SEVERAL_CONDITIONS_(OR)_STEPS@la1n50en.hlp>Steps 4 Finding records with OR conditions in more than one field=H_FINDING_RECORDS_WITH_OR_CONDITIONS_IN_MORE_THAN_ONE_FIELD_STEPS@la1n50en.hlp>Steps 4 Finding text with wildcards=H_FINDING_TEXT_WITH_WILDCARDS_STEPS@la1n50en.hlp>Steps 4 Finding case-sensitive text=H_FINDING_CASESENSITIVE_TEXT_STEPS@la1n50en.hlp>Steps 4 Finding a word that sounds like another=H_FINDING_A_WORD_THAT_SOUNDS_LIKE_ANOTHER_STEPS@la1n50en.hlp>Steps 4 Finding numbers, dates, and times=H_FINDING_NUMBERS_DATES_AND_TIMES_STEPS@la1n50en.hlp>Steps 4 Finding values in a range=H_FINDING_VALUES_IN_A_RANGE_STEPS@la1n50en.hlp>Steps 4 Finding today's date=H_FINDING_TODAYS_DATE_STEPS@la1n50en.hlp>Steps 4 Finding radio button and check box settings=H_FINDING_RADIO_BUTTON_AND_CHECK_BOX_SETTINGS_STEPS@la1n50en.hlp>Steps 4 Finding blank or nonblank fields=H_FINDING_BLANK_OR_NONBLANK_FIELDS_STEPS@la1n50en.hlp>Steps 4 Using If statements to find data=H_USING_IF_STATEMENTS_TO_FIND_DATA_STEPS@la1n50en.hlp>Steps 4 Repeating finds=H_REPEATING_FINDS_STEPS@la1n50en.hlp>Steps 3 Create Named Finds 4 Naming finds with the Find Assistant=H_NAMING_FINDS_WITH_THE_FIND_ASSISTANT_STEPS@la1n50en.hlp>Steps 4 Naming and reviewing finds with the Find Assistant=H_NAMING_AND_REVIEWING_FINDS_WITH_THE_FIND_ASSISTANT_REF@la1n50en.hlp>Overview 4 Naming finds based on find requests=H_NAMING_FINDS_BASED_ON_FIND_REQUESTS_STEPS@la1n50en.hlp>Steps 4 Editing named finds=H_EDITING_NAMED_FINDS_STEPS@la1n50en.hlp>Steps 4 Copying named finds=H_COPYING_NAMED_FINDS_STEPS@la1n50en.hlp>Steps 4 Deleting named finds=H_DELETING_NAMED_FINDS_STEPS@la1n50en.hlp>Steps 4 Running named finds=H_RUNNING_NAMED_FINDS_STEPS@la1n50en.hlp>Steps 3 Create Query Files 4 Creating query files in Approach=H_CREATING_QUERY_FILES_IN_APPROACH_STEPS@la1n50en.hlp>Steps 4 Opening query files in Approach=H_OPENING_QUERY_FILES_IN_APPROACH_STEPS@la1n50en.hlp>Steps 4 Saving or exporting data from a query=H_SAVING_OR_EXPORTING_DATA_FROM_A_QUERY_STEPS@la1n50en.hlp>Steps 3 Create an SQL SELECT Statement with the SQL Assistant 4 Overview: Connecting to an SQL or ODBC data source=H_CONNECTING_TO_AN_SQL_OR_ODBC_DATA_SOURCE_OVER@la1n50en.hlp>Overview 4 Selecting tables for an SQL SELECT statement=H_SELECTING_TABLES_IN_THE_TABLES_TAB_STEPS@la1n50en.hlp>Steps 4 Creating joins for an SQL SELECT statement=H_CREATING_JOINS_IN_THE_JOIN_TAB_STEPS@la1n50en.hlp>Steps 4 Creating find conditions for an SQL SELECT statement=H_CREATING_FIND_CONDITIONS_IN_THE_CONDITION_TAB_STEPS@la1n50en.hlp>Steps 4 Selecting fields for an SQL SELECT statement=H_SELECTING_FIELDS_IN_THE_FIELDS_TAB_STEPS@la1n50en.hlp>Steps 4 Sorting fields for an SQL SELECT statement=H_SORTING_FIELDS_IN_THE_SORT_TAB_STEPS@la1n50en.hlp>Steps 4 Editing SQL statements=H_EDITING_SQL_STATEMENTS_IN_THE_SQL_TAB_STEPS@la1n50en.hlp>Steps 2 Sort Records 3 Specifying a sort order=H_SPECIFYING_A_SORT_ORDER_STEPS@la1n50en.hlp>Steps 3 Sorting records by a field in a view (Ascending)=H_SORTING_RECORDS_BY_A_FIELD_IN_A_VIEW_ASCENDING_STEPS@la1n50en.hlp>Steps 3 Sorting records by a field in a view (Descending)=H_SORTING_RECORDS_BY_A_FIELD_IN_A_VIEW_DESCENDING_STEPS@la1n50en.hlp>Steps 3 Setting a default sort order for looking at records in Browse=H_SETTING_A_DEFAULT_SORT_ORDER_FOR_RECORDS_IN_BROWSE_STEPS@la1n50en.hlp>Steps 3 Setting a default sort order for a repeating panel=H_SORTING_RECORDS_IN_REPEATING_PANELS_STEPS@la1n50en.hlp>Steps 2 Work with a Team Using Approach 3 Share Work within Groups Using TeamMail 4 Sending e-mail messages from inside Approach=H_SENDING_EMAIL_MESSAGES_FROM_INSIDE_APPROACH_STEPS@la1n50en.hlp>Steps 4 Sending e-mail messages with attachments from inside Approach=H_SENDING_EMAIL_MESSAGES_WITH_ATTACHMENTS_FROM_INSIDE_APPROACH_STEPS@la1n50en.hlp>Steps :include TM1N11EN.CNT 3 Protect Approach Files with TeamSecurity 4 Overview: Passwords=H_PASSWORDS_OVER@la1n50en.hlp>Overview 4 TeamSecurity=H_TEAMSECURITY_REF@la1n50en.hlp>Overview 4 Defining password privileges using Copy=H_DEFINING_PASSWORD_PRIVILEGES_USING_COPY_STEPS@la1n50en.hlp>Steps 4 Defining password privileges using New =H_DEFINING_PASSWORD_PRIVILEGES_USING_NEW_STEPS@la1n50en.hlp>Steps 4 Editing password privileges=H_EDITING_PASSWORD_PRIVILEGES_STEPS@la1n50en.hlp>Steps 4 Deleting groups or users=H_DELETING_GROUPS_OR_USERS_STEPS@la1n50en.hlp>Steps 4 Confirming passwords=H_CONFIRMING_PASSWORDS_STEPS@la1n50en.hlp>Steps 4 Entering data using optimistic record locking=H_ENTERING_DATA_USING_OPTIMISTIC_RECORD_LOCKING_STEPS@la1n50en.hlp>Steps 2 Share Data with Other Applications 3 Import Data 4 Importing data into databases=H_IMPORTING_DATA_INTO_DATABASES_STEPS@la1n50en.hlp>Steps 4 Opening databases created in other applications=H_OPENING_DATABASES_CREATED_IN_OTHER_APPLICATIONS_STEPS@la1n50en.hlp>Steps 4 Creating databases from spreadsheets=H_CREATING_DATABASES_FROM_SPREADSHEETS_STEPS@la1n50en.hlp>Steps 4 Creating databases from delimited text files=H_CREATING_DATABASES_FROM_DELIMITED_TEXT_FILES_STEPS@la1n50en.hlp>Steps 4 Creating databases from fixed-length text files=H_CREATING_DATABASES_FROM_FIXEDLENGTH_TEXT_FILES_STEPS@la1n50en.hlp>Steps 4 Importing Approach files=H_IMPORTING_APPROACH_FILES_STEPS@la1n50en.hlp>Steps 4 Mapping fields=H_MAPPING_FIELDS_REF@la1n50en.hlp>Overview 4 Pasting pictures in fields=H_PASTING_PICTURES_IN_FIELDS_STEPS@la1n50en.hlp>Steps 3 Export Data 4 Exporting data from Approach=H_EXPORTING_DATA_FROM_APPROACH_STEPS@la1n50en.hlp>Steps 4 Copying PicturePlus pictures to a file=H_COPYING_PICTUREPLUS_PICTURES_TO_A_FILE_STEPS@la1n50en.hlp>Steps 3 Link and Embed Objects (OLE) 4 Overview: Communicating between applications using OLE=H_COMMUNICATING_BETWEEN_APPLICATIONS_USING_OLE_OVER@la1n50en.hlp>Overview 4 Overview: OLE links=H_OLE_LINKS_OVER@la1n50en.hlp>Overview 4 Overview: OLE embedded objects=H_OLE_EMBEDDED_OBJECTS_OVER@la1n50en.hlp>Overview 4 Overview: Embedding an Approach object in another application=H_EMBEDDING_AN_APPROACH_OBJECT_IN_ANOTHER_APPLICATION_OVER@la1n50en.hlp>Overview 4 Creating Approach OLE objects in Approach (Copy View)=H_CREATING_APPROACH_OLE_OBJECTS_IN_APPROACH_STEPS@la1n50en.hlp>Steps 4 Creating Approach OLE objects from other applications=H_CREATING_APPROACH_OLE_OBJECTS_FROM_OTHER_APPLICATIONS_STEPS@la1n50en.hlp>Steps 4 Creating linked objects from files=H_CREATING_OLE_OBJECTS_FROM_FILES_STEPS@la1n50en.hlp>Steps 4 Inserting linked objects from the Clipboard=H_INSERTING_LINKED_OBJECTS_FROM_THE_CLIPBOARD_STEPS@la1n50en.hlp>Steps 4 Editing linked objects=H_EDITING_LINKED_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Modifying links=H_MODIFYING_LINKS_BETWEEN_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Embedding OLE objects based on existing files=H_EMBEDDING_EXISTING_OLE_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Embedding new OLE objects=H_EMBEDDING_NEW_OLE_OBJECTS_STEPS@la1n50en.hlp>Steps 4 Editing embedded objects=H_EDITING_EMBEDDED_OBJECTS_STEPS@la1n50en.hlp>Steps 3 Work with Custom Controls (OCX) 4 Overview: OLE Custom Controls=H_OLE_CUSTOM_CONTROLS_OVER@la1n50en.hlp>Overview 4 Registering custom controls=H_REGISTERING_CUSTOM_CONTROLS_STEPS@la1n50en.hlp>Steps 4 Inserting custom controls in views=H_INSERTING_CUSTOM_CONTROLS_IN_VIEWS_STEPS@la1n50en.hlp>Steps 4 Changing properties of custom controls=H_CHANGING_PROPERTIES_OF_CUSTOM_CONTROLS_STEPS@la1n50en.hlp>Steps 4 Adding custom controls to the Tools palette=H_ADDING_CUSTOM_CONTROLS_TO_THE_TOOLS_PALETTE_STEPS@la1n50en.hlp>Steps 2 Share Data on a Network 3 Setting file-sharing options for dBASE files=H_SETTING_FILESHARING_OPTIONS_FOR_DBASE_FILES_STEPS@la1n50en.hlp>Steps 3 Specifying locking protocols for shared dBASE files=H_SPECIFYING_LOCKING_PROTOCOLS_FOR_SHARED_DBASE_FILES_STEPS@la1n50en.hlp>Steps 3 Setting file-sharing options for Paradox files=H_SETTING_FILESHARING_OPTIONS_FOR_PARADOX_FILES_STEPS@la1n50en.hlp>Steps 3 Opening QMF files in Approach=H_OPENING_QMF_FILES_IN_APPROACH_STEPS@la1n50en.hlp>Steps 3 Importing QMF forms in Approach=H_IMPORTING_QMF_FORMS_IN_APPROACH_STEPS@la1n50en.hlp>Steps 3 Importing QMF queries in Approach=H_IMPORTING_QMF_QUERIES_IN_APPROACH_STEPS@la1n50en.hlp>Steps 3 Changing the status to single-user=H_CHANGING_THE_STATUS_TO_SINGLE_USER_STEPS@la1n50en.hlp>Steps 3 Entering passwords=H_ENTERING_PASSWORDS_STEPS@la1n50en.hlp>Steps 3 Refreshing the data network onscreen=H_REFRESHING_THE_DATA_NETWORK_ONSCREEN_STEPS@la1n50en.hlp>Steps 3 Saving changes to shared records=H_SAVING_CHANGES_TO_SHARED_RECORDS_STEPS@la1n50en.hlp>Steps 3 Troubleshoot Servers 4 Troubleshooting IBM DB2 using CAE=H_TROUBLESHOOTING_IBM_DB2_USING_CAE_REF@la1n50en.hlp>Overview 4 Troubleshooting Microsoft SQL Server=H_TROUBLESHOOTING_MICROSOFT_SQL_SERVER_REF@la1n50en.hlp>Overview 4 Troubleshooting Oracle Server=H_TROUBLESHOOTING_ORACLE_SQL_ON_A_SERVER_REF@la1n50en.hlp>Overview 4 Troubleshooting Sybase SQL Server 4.x=H_TROUBLESHOOTING_SYBASE_SQL_SERVER_REF@la1n50en.hlp>Overview 4 Troubleshooting Sybase System 10 and 11=H_TROUBLESHOOTING_SYBASE_SYSTEM_10_AND_11_REF@la1n50en.hlp>Overview 2 Customize Approach 3 Set Approach Preferences 4 Setting display preferences for the Approach window=H_SETTING_DISPLAY_PREFERENCES_FOR_THE_APPROACH_WINDOW_REF@la1n50en.hlp>Overview 4 Showing summaries in reports=H_SETTING_DISPLAY_PREFERENCES_FOR_THE_APPROACH_WINDOW_REF@la1n50en.hlp>Overview 4 Setting preferences for the Design environment=H_SETTING_PREFERENCES_FOR_THE_DESIGN_ENVIRONMENT_REF@la1n50en.hlp>Overview 4 Adding custom controls to the Tools palette=H_ADDING_CUSTOM_CONTROLS_TO_THE_TOOLS_PALETTE_STEPS@la1n50en.hlp>Steps 4 Setting a default sort order for looking at records in Browse=H_SETTING_A_DEFAULT_SORT_ORDER_FOR_RECORDS_IN_BROWSE_STEPS@la1n50en.hlp>Steps 4 Defining passwords for a database=H_DEFINING_PASSWORDS_FOR_A_DATABASE_STEPS@la1n50en.hlp>Steps 4 Identifying default directories=H_IDENTIFYING_DEFAULT_DIRECTORIES_STEPS@la1n50en.hlp>Steps 4 Displaying the contents of drop-down boxes automatically=H_DISPLAYING_THE_CONTENTS_OF_DROPDOWN_BOXES_AUTOMATICALLY_STEPS@la1n50en.hlp>Steps 4 Moving between fields using ENTER=H_MOVING_BETWEEN_FIELDS_USING_ENTER_STEPS@la1n50en.hlp>Steps 4 Showing the Add Field dialog box after creating new fields=H_SHOWING_THE_ADD_FIELD_DIALOG_BOX_AFTER_CREATING_NEW_FIELDS_STEPS@la1n50en.hlp>Steps 4 Showing the Cancel Macro dialog box while running macros=H_SHOWING_THE_CANCEL_MACRO_DIALOG_BOX_WHILE_RUNNING_MACROS_STEPS@la1n50en.hlp>Steps 4 Making calculated fields available for joins=H_MAKING_CALCULATED_FIELDS_AVAILABLE_FOR_JOINS_STEPS@la1n50en.hlp>Steps 4 Entering data using optimistic record locking=H_ENTERING_DATA_USING_OPTIMISTIC_RECORD_LOCKING_STEPS@la1n50en.hlp>Steps 4 Downloading data before previewing=H_DOWNLOADING_DATA_BEFORE_PREVIEWING_STEPS@la1n50en.hlp>Steps 4 Setting dialing preferences=H_SETTING_DIALING_PREFERENCES_REF@la1n50en.hlp>Overview 4 Setting preferences for database files=H_SETTING_PREFERENCES_FOR_DATABASE_FILES_REF@la1n50en.hlp>Overview 3 Customize Menus 4 Custom menus=H_CUSTOM_MENUS_REF@la1n50en.hlp>Overview 4 Creating custom menus=H_CREATING_CUSTOM_MENUS_STEPS@la1n50en.hlp>Steps 4 Creating a custom menu by copying one that exists=H_CREATING_A_CUSTOM_MENU_BY_COPYING_ONE_THAT_EXISTS_STEPS@la1n50en.hlp>Steps 4 Editing custom menus=H_EDITING_CUSTOM_MENUS_STEPS@la1n50en.hlp>Steps 4 Moving and deleting commands on custom menus=H_MOVING_AND_DELETING_CUSTOMMENU_COMMANDS_STEPS@la1n50en.hlp>Steps 4 Deleting custom menus=H_DELETING_CUSTOM_MENUS_STEPS@la1n50en.hlp>Steps 1 Working with Approach and the Internet 2 Overview: Working with the Internet=H_WORKING_WITH_THE_INTERNET_OVER@la1n50en.hlp>Overview 2 Showing the Internet Tools palette=H_SHOWING_THE_INTERNET_TOOLS_PALETTE_STEPS@la1n50en.hlp>Steps 2 Setting automatic connections to the Internet=H_SETTING_AUTOMATIC_CONNECTIONS_TO_THE_INTERNET_STEPS@la1n50en.hlp>Steps 2 Connecting to Internet servers=H_CONNECTING_TO_INTERNET_SERVERS_STEPS@la1n50en.hlp>Steps 2 Editing connections to Internet servers=H_EDITING_CONNECTIONS_TO_INTERNET_SERVERS_STEPS@la1n50en.hlp>Steps 2 Deleting connections to Internet servers=H_DELETING_CONNECTIONS_TO_INTERNET_SERVERS_STEPS@la1n50en.hlp>Steps 2 Managing proxies=H_MANAGING_PROXIES_STEPS@la1n50en.hlp>Steps 2 Saving Approach views to the Internet=H_SAVING_APPROACH_VIEWS_TO_THE_INTERNET_STEPS@la1n50en.hlp>Steps 2 Saving Approach views to other file formats=H_SAVING_APPROACH_VIEWS_TO_OTHER_FILE_FORMATS_STEPS@la1n50en.hlp>Steps 2 Overview: Opening Approach files from a server on the Internet=H_OPENING_APPROACH_FILES_FROM_A_SERVER_ON_THE_INTERNET_OVER@la1n50en.hlp>Overview 2 Opening Approach files from a Web server on the Internet=H_OPENING_APPROACH_FILES_FROM_A_WEB_SERVER_ON_THE_INTERNET_STEPS@la1n50en.hlp>Steps 2 Opening Approach files from an FTP server on the Internet=H_OPENING_APPROACH_FILES_FROM_AN_FTP_SERVER_ON_THE_INTERNET_STEPS@la1n50en.hlp>Steps 1 Demo Catalog 2 Using demos=H_USING_DEMOS_REF@la1n50en.hlp>Overview 1 Tools for Getting Your Work Done 2 Installing additional language versions of Approach=H_INSTALLING_ADDITIONAL_LANGUAGE_VERSIONS_OF_APPROACH_OVER@la1n50en.hlp>Overview 2 Keyboard Information 3 Moving between fields=H_MOVING_BETWEEN_FIELDS_REF@la1n50en.hlp>Overview 3 Keyboard shortcuts=H_KEYBOARD_SHORTCUTS_REF@la1n50en.hlp>Overview 3 Moving within fields=H_MOVING_WITHIN_FIELDS_REF@la1n50en.hlp>Overview 3 Selecting within fields=H_SELECTING_WITHIN_FIELDS_REF@la1n50en.hlp>Overview 2 Menus 3 Shortcut menus=H_SHORTCUT_MENUS_STEPS@la1n50en.hlp>Steps 3 File menu=H_FILE_MENU_REF@la1n50en.hlp>Overview 3 Edit menu=H_EDIT_MENU_REF@la1n50en.hlp>Overview 3 View menu=H_VIEW_MENU_REF@la1n50en.hlp>Overview 3 Create menu=H_CREATE_MENU_REF@la1n50en.hlp>Overview 3 Window menu=H_WINDOW_MENU_REF@la1n50en.hlp>Overview 3 Help menu=H_HELP_MENU_REF@la1n50en.hlp>Overview 3 Context Menus 4 Browse menu=H_BROWSE_MENU_REF@la1n50en.hlp>Overview 4 Chart menu=H_CHART_MENU_REF@la1n50en.hlp>Overview 4 Column menu=H_COLUMN_MENU_REF@la1n50en.hlp>Overview 4 Crosstab menu=H_CROSSTAB_MENU_REF@la1n50en.hlp>Overview 4 Envelope menu=H_ENVELOPE_MENU_REF@la1n50en.hlp>Overview 4 Form menu=H_FORM_MENU_REF@la1n50en.hlp>Overview 4 Form Letter menu=H_FORM_LETTER_MENU_REF@la1n50en.hlp>Overview 4 Mailing Label menu=H_MAILING_LABEL_MENU_REF@la1n50en.hlp>Overview 4 Object menu=H_OBJECT_MENU_REF@la1n50en.hlp>Overview 4 Report menu=H_REPORT_MENU_REF@la1n50en.hlp>Overview 4 Text menu=H_TEXT_MENU_REF@la1n50en.hlp>Overview 4 Worksheet menu=H_WORKSHEET_MENU_REF@la1n50en.hlp>Overview 2 SmartIcons 3 Overview: SmartIcons=H_SMARTICONS_OVER@la1n50en.hlp>Overview 3 Overview: Using SmartIcons=H_USING_SMARTICONS_OVER@la1n50en.hlp>Overview 3 Using an icon=H_USING_AN_ICON_STEPS@la1n50en.hlp>Steps 3 Modifying a Set of SmartIcons 4 Adding an icon to a set of SmartIcons=H_ADDING_AN_ICON_TO_A_SET_OF_SMARTICONS_STEPS@la1n50en.hlp>Steps 4 Removing an icon from a set of SmartIcons=H_REMOVING_AN_ICON_FROM_A_SET_OF_SMARTICONS_STEPS@la1n50en.hlp>Steps 4 Sizing icons in a SmartIcons set=H_SIZING_ICONS_IN_A_SMARTICONS_SET_STEPS@la1n50en.hlp>Steps 4 Spacing between SmartIcons in a set=H_SPACING_BETWEEN_SMARTICONS_IN_A_SET_STEPS@la1n50en.hlp>Steps 4 Creating a new SmartIcons set=H_CREATING_A_NEW_SMARTICONS_SET_STEPS@la1n50en.hlp>Steps 4 Deleting a SmartIcons set=H_DELETING_A_SMARTICONS_SET_STEPS@la1n50en.hlp>Steps 4 Displaying or hiding SmartIcons bubble help=H_DISPLAYING_OR_HIDING_SMARTICONS_BUBBLE_HELP_STEPS@la1n50en.hlp>Steps 3 SmartIcons in the Work Area 4 Overview: Placing SmartIcons in the work area=H_PLACING_SMARTICONS_ON_THE_WORKSPACE_OVER@la1n50en.hlp>Overview 4 Placing a set of SmartIcons using the mouse=H_PLACING_A_SET_OF_SMARTICONS_USING_THE_MOUSE_STEPS@la1n50en.hlp>Steps 4 Selecting and displaying a specific icon set=H_SELECTING_AND_DISPLAYING_A_SPECIFIC_ICON_SET_STEPS@la1n50en.hlp>Steps 4 Displaying or hiding SmartIcons=H_DISPLAYING_OR_HIDING_SMARTICONS_STEPS@la1n50en.hlp>Steps 4 Hiding SmartIcons using the bar button=H_HIDING_SMARTICONS_USING_THE_BAR_BUTTON_STEPS@la1n50en.hlp>Steps 4 Moving an icon using the mouse=H_MOVING_AN_ICON_USING_THE_MOUSE_STEPS@la1n50en.hlp>Steps 4 Selecting a SmartIcons set using the bar button=H_SELECTING_A_SMARTICONS_SET_USING_THE_BAR_BUTTON_STEPS@la1n50en.hlp>Steps 4 Setting location preferences for context SmartIcons=H_SETTING_LOCATION_PREFERENCES_FOR_CONTEXT_SMARTICONS_STEPS@la1n50en.hlp>Steps 2 Functions 3 List of functions=H_FUNCTIONS_ALPHA_REF@la1n50en.hlp>Overview 3 Overview: Functions=H_FUNCTIONS_OVER@la1n50en.hlp>Overview 3 Overview: Formulas=H_FORMULAS_OVER@la1n50en.hlp>Overview 3 Overview: Field references, constants, and operators=H_OPERATORS_OVER@la1n50en.hlp>Overview 3 Date and time constants=H_DATE_AND_TIME_CONSTANTS_REF@la1n50en.hlp>Overview 2 Macros 3 List of macro commands=H_MACRO_COMMANDS_ALPHA_REF@la1n50en.hlp>Overview 3 Overview: Macros=H_MACROS_OVER@la1n50en.hlp>Overview 3 Define Macro dialog box=H_DEFINE_MACRO_DIALOG_BOX_REF>Overview 3 Printing macros=H_PRINTING_MACRO_COMMANDS_STEPS>Steps 3 Running script functions with a macro=H_RUNNING_SCRIPT_FUNCTIONS_WITH_A_MACRO_STEPS>Steps 3 Write Macros 4 Creating new macros=H_CREATING_NEW_MACROS_STEPS@la1n50en.hlp>Steps 4 Recording macros and scripts=H_RECORDING_MACROS_AND_SCRIPTS_STEPS@la1n50en.hlp>Steps 4 Creating macros based on existing macros=H_CREATING_MACROS_BASED_ON_EXISTING_MACROS_STEPS>Steps 4 Editing macros=H_EDITING_MACROS_STEPS@la1n50en.hlp>Steps 4 Deleting macros=H_DELETING_MACROS_STEPS@la1n50en.hlp>Steps 4 Attaching macros=H_ATTACHING_MACROS_STEPS@la1n50en.hlp>Steps 4 Adding macros to the Run Macro menu=H_ADDING_MACROS_TO_THE_RUN_MACRO_MENU_STEPS@la1n50en.hlp>Steps 4 Creating keystroke sequences in macros=H_CREATING_KEYSTROKE_SEQUENCES_IN_MACROS_STEPS@la1n50en.hlp>Steps 4 Converting macros to scripts=H_CONVERTING_MACROS_TO_SCRIPTS_STEPS@la1n50en.hlp>Steps 3 Use Macros: Suggestions for Use 4 Creating looping macros=H_CREATING_LOOPING_MACROS_STEPS@la1n50en.hlp>Steps 4 Defining a conditional macro=H_DEFINING_A_CONDITIONAL_MACRO_STEPS@la1n50en.hlp>Steps 4 Running macros from buttons in a message box=H_RUNNING_MACROS_FROM_BUTTONS_IN_A_MESSAGE_BOX_STEPS>Steps 4 Setting a value in a field with a macro=H_SETTING_A_VALUE_IN_A_FIELD_WITH_A_MACRO_STEPS@la1n50en.hlp>Steps 4 Switching to another view with a macro=H_SWITCHING_TO_ANOTHER_VIEW_WITH_A_MACRO_STEPS@la1n50en.hlp>Steps 2 File Types 3 File extensions in Approach=H_FILE_EXTENSIONS_IN_APPROACH_REF@la1n50en.hlp>Overview 3 dBASE files in Approach=H_DBASE_FILES_IN_APPROACH_REF@la1n50en.hlp>Overview 3 FoxPro files in Approach=H_FOXPRO_FILES_IN_APPROACH_REF@la1n50en.hlp>Overview 3 IBM DB2 tables in Approach=H_IBM_DB2_TABLES_IN_APPROACH_REF@la1n50en.hlp>Overview 3 QMF Files in Approach=H_QMF_FILES_IN_APPROACH_REF@la1n50en.hlp>Overview 3 ODBC data sources in Approach=H_ODBC_DATA_SOURCES_IN_APPROACH_REF@la1n50en.hlp>Overview 3 Oracle SQL tables in Approach=H_ORACLE_SQL_TABLES_IN_APPROACH_REF@la1n50en.hlp>Overview 3 Paradox files in Approach=H_PARADOX_FILES_IN_APPROACH_REF@la1n50en.hlp>Overview 3 Query files in Approach=H_QUERY_FILES_IN_APPROACH_REF@la1n50en.hlp>Overview 3 SQL Server 4.x tables in Approach=H_SQL_SERVER_TABLES_IN_APPROACH_REF@la1n50en.hlp>Overview 3 Lotus Notes files in Approach=H_LOTUS_NOTES_FILES_IN_APPROACH_REF@la1n50en.hlp>Overview 3 Microsoft Access tables in Approach=H_MICROSOFT_ACCESS_TABLES_IN_APPROACH_REF@la1n50en.hlp>Overview 1 Did You Know. . . 2 Browse is for data, Design is for style=H_BROWSE_IS_FOR_DATA_DESIGN_IS_FOR_STYLE_REF@la1n50en.hlp>Overview 2 Approach saves data automatically=H_APPROACH_SAVES_DATA_AUTOMATICALLY_REF@la1n50en.hlp>Overview 2 A sort is not a find=H_A_SORT_IS_NOT_A_FIND_REF@la1n50en.hlp>Overview 2 Select Print Preview to see report summaries=H_SELECT_PRINT_PREVIEW_TO_SEE_REPORT_SUMMARIES_REF@la1n50en.hlp>Overview 1 LotusScript 2 Using LotusScript in Approach=H_USING_LOTUSSCRIPT_IN_APPROACH_OVER@la1n50en.hlp>Overview 1 What's New for Upgraders 2 What's new in Approach 97=H_WHATS_NEW_IN_APPROACH_97_REF@la1n50en.hlp>Overview 2 Installing additional language versions of Approach=H_INSTALLING_ADDITIONAL_LANGUAGE_VERSIONS_OF_APPROACH_OVER@la1n50en.hlp>Overview 1 Using Applications Together 2 Working Together with Lotus Notes 3 Opening Lotus Notes views or forms from a local Notes database=H_OPENING_LOTUS_NOTES_VIEWS_OR_FORMS_FROM_A_LOCAL_NOTES_DATABASE_STEPS@la1n50en.hlp>Steps 3 Opening Lotus Notes views or forms from a Notes database on a server=H_OPENING_LOTUS_NOTES_VIEWS_OR_FORMS_FROM_A_NOTES_DATABASE_ON_A_SERVER_STEPS@la1n50en.hlp>Steps 3 Replicating a Notes database=H_REPLICATING_A_NOTES_DATABASE_STEPS@la1n50en.hlp>Steps 3 Replicating Notes databases with a server=H_REPLICATING_NOTES_DATABASES_WITH_A_SERVER_STEPS@la1n50en.hlp>Steps 3 Notes/FX 4 Enabling variable fields for Notes/FX=H_ENABLING_VARIABLE_FIELDS_FOR_NOTES_FX_STEPS@la1n50en.hlp>Steps 4 Overview: Exchanging data between Approach and Notes=H_EXCHANGING_DATA_BETWEEN_APPROACH_AND_NOTES_OVER@la1n50en.hlp>Overview 4 Overview: Setting up Notes/FX=H_SETTING_UP_NOTES_FIELD_EXCHANGE_OVER@la1n50en.hlp>Overview 4 Setting up fields for two-way exchange with Notes=H_SETTING_UP_FIELDS_FOR_TWOWAY_EXCHANGE_WITH_NOTES_STEPS@la1n50en.hlp>Steps 4 Adding Notes/FX fields to a Notes form=H_ADDING_NOTESFX_FIELDS_TO_A_NOTES_FORM_STEPS@la1n50en.hlp>Steps 4 Embedding an Approach object in a Notes document=H_EMBEDDING_AN_APPROACH_OBJECT_IN_AN_EXISTING_NOTES_FORM_STEPS@la1n50en.hlp>Steps 4 Embedding an Approach object in a Notes form=H_EMBEDDING_AN_APPROACH_OBJECT_IN_A_NOTES_FORM_DESIGN_STEPS@la1n50en.hlp>Steps 4 Creating a new Notes document=H_CREATING_A_NEW_NOTES_DOCUMENT_STEPS@la1n50en.hlp>Steps 4 Updating fields in a Notes document from Approach=H_UPDATING_FIELDS_IN_A_NOTES_DOCUMENT_FROM_APPROACH_STEPS@la1n50en.hlp>Steps 4 Updating information in Approach from a Notes document=H_UPDATING_INFORMATION_IN_APPROACH_FROM_A_NOTES_DOCUMENT_STEPS@la1n50en.hlp>Steps 2 Working Together with Lotus 1-2-3 3 Opening 1-2-3 named ranges in Approach=H_OPENING_NAMED_RANGES_FROM_LOTUS_123_SPREADSHEETS_STEPS@la1n50en.hlp>Steps 3 Creating Approach views in Lotus 1-2-3=H_CREATING_APPROACH_VIEWS_IN_LOTUS_123_STEPS@la1n50en.hlp>Steps 3 Creating databases from spreadsheets=H_CREATING_DATABASES_FROM_SPREADSHEETS_STEPS@la1n50en.hlp>Steps 1 Troubleshooting :include cs1n97en.cnt 2 Messages 3 Common messages=H_COMMON_MESSAGES_IN_APPROACH_REF@la1n50en.hlp>Overview 2 Connecting to Servers 3 Troubleshooting IBM DB2 using CAE=H_TROUBLESHOOTING_IBM_DB2_USING_CAE_REF@la1n50en.hlp>Overview 3 Troubleshooting Microsoft SQL Server=H_TROUBLESHOOTING_MICROSOFT_SQL_SERVER_REF@la1n50en.hlp>Overview 3 Troubleshooting Oracle Server=H_TROUBLESHOOTING_ORACLE_SQL_ON_A_SERVER_REF@la1n50en.hlp>Overview 3 Troubleshooting Sybase SQL Server 4.x=H_TROUBLESHOOTING_SYBASE_SQL_SERVER_REF@la1n50en.hlp>Overview 3 Troubleshooting Sybase System 10 and 11=H_TROUBLESHOOTING_SYBASE_SYSTEM_10_AND_11_REF@la1n50en.hlp>Overview 2 Did You Know. . . 3 Browse is for data, Design is for style=H_BROWSE_IS_FOR_DATA_DESIGN_IS_FOR_STYLE_REF@la1n50en.hlp>Overview 3 Approach saves data automatically=H_APPROACH_SAVES_DATA_AUTOMATICALLY_REF@la1n50en.hlp>Overview 3 A sort is not a find=H_A_SORT_IS_NOT_A_FIND_REF@la1n50en.hlp>Overview 3 Select Print Preview to see report summaries=H_SELECT_PRINT_PREVIEW_TO_SEE_REPORT_SUMMARIES_REF@la1n50en.hlp>Overview 1 ODBC Database Drivers :include IVDRV09.CNT