Grid Info

Roster Grid	The roster grid contains the basic personal information for members.
Dual Address Members	Many squadrons have the problem of dealing with dual address members. National's database does not support dual addresses but DB2000 can support this locally using the following rules: Members selected for dual address support will no longer have their address or related fields updated by roster imports from national. This is because there is no way of knowing what data is currently in the HQ database. Remember that no matter how diligently you have been updating national from DB2000, many times individual members advise HQ of their current address to make sure they receive their Ensign Any time a dual address member's location is changed, the BDU upload can be made to keep HQ advised of the current address. It raises a dialog asking if this is required whenever a changeover is made. There are two columns on the roster grid , "DA" and "Swap". To assign a member to dual address status, select the "DA" cell in the member's grid row and press Enter. This will raise a dialog asking which location to assign the current address. Make a selection and the cell content will reflect this by displaying "H" for home, or "A" for away. The grid can be toggled between the two using the "Swap" cell. Alternate address into the grid directly as when editing, or the BDU form may be used which will reflect the location selected. If for any reason the two locations are reversed, this can be corrected using the "<>" button at the top of the roster form. This simply reverses the H and A labels. Note: Dual address status can be removed in a similar way. The dialog asks which address to retain.
Grade Grid	The grade grid is a non-editable grid containing each members grade history. It also contains the number of merit marks and senior / life membership status. When a roster download is made, the file contains information on course modules that may have been passed. DB2000 dynamically creates new columns as needed to contain this information. The column order can be adjusted so that modules appertaining to a specific grade may be collocated if desired.
History Grid	The history grid is a non-editable grid each members USPS history. Certificate date, membership years, membership status etc.. Double clicking or pressing Enter on a squadron cell will show the name of that squadron and it's district.
Boat Grid	The boat grid contains three fields belonging to the BDU and a number of other fields offered for keeping boat information.
Communications Grid	This useful grid is communication central for DB2000. It contains all telephone, fax and email address information. The Windows telephone dialer utility can be launched by highlighting the telephone number to dial and clicking the "Dial" button. If the utility cannot be found a dialog is provided to allow the user to enter the path to it's location. A single member can be emailed by highlighting the address and clicking on the address box at the top of the grid. Multiple members can be emailed by tagging the records desired. See tag options. Bulk area code changes can also be made using the tag options.
User Grid Name format in D&D printer.	This grid shows information contained in user defined fields. In also shows the information in two fields included in the roster download, Squad1 and Squad2. These were supplied for squadron use by HQ and can contain any squadron related data. Because these fields are in each download and are updated via the BDU they must be considered public since everyone who downloads a roster will get the information. For this reason these fields should be used for an agreed squadron wide use. This doesn't apply to district databases since data can't be uploaded to HQ. The user can define any number of other fields of several data types. These are local to the user's machine and can be used for any private purpose. The data can be shared with others by using "Export User Defined Field" in the Options Menu. This makes a data file that can be passed to other users. They can import it, automatically creating and filling the field. To define a new field under the Options menu select "Field Options". In the resulting dialog form the user can define a new field, delete an unwanted field, change a name etc.. Once a field is created it can be used as desired. The field can be of several types, text, numeric, currency, yes/no or memo. The length of a text field must be defined, 255 chars. max. A memo field can contain very long texts and formatting. Note: To close a memo field, a button is provided at the top of the screen. Can't use the usual Enter since this is a legitimate formatting key in memo mode. There is an option to fill a field with pre-selected data. These selections are primarily used to help in report preparation when using Report Wizard. For example, the primary database tables do not contain the squadron name. This must be derived from the squadron code field by cross referencing it to the HQ reference database. Report Wizard has no way to do this so a user field containing this information solves the problem. The selection is provided to save the user having to key the data. Other selections are lists of passed courses and various name/grade/rank formats. This feature is sometimes referred to as a data stuffer. User fields can also be used in DB2000's Down and Dirty Roster Printer and the name formats provide a means of editing names, which is not available via the protected BDU fields. The user name field can be used by selecting it from the D&D Roster Printer dropdown list. The D&D Roster Printer can also print the information from discretionary field selections which include user defined. Another useful option is assigning a field content to the tag list. Any record in that field that has content sets the tag. Tagged data can be used in generating database queries and for defining the member list for the D&D Roster Printer. See Tag options