BDU Grid Information
|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:
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.
|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
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.
||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.|
|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.
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.