Observe the  **Data Files**  Prompts for the Schedule Templates.

The Daily and Monthly prompts are identical.

Monthly:

The Resource File Ideally Needs a SysId(Long) With a key on it.  This field does not have to be a long, but must be unique to identify the Resource.  It also needs a field(s) with the "Information to Display" in the Resource Column or Left Row in the Listbox.  The Resource Display is an Expression Field, so it can be built from other fields.

You can Optionally use another key to determine the display order of the Resources.  You can use your existing files as Resources, and possibly modify them (if needed) to meet these minimum requirements.

Resource File

ResourceId    Key(Unique)

ResourceName    Key(Optional for Display)

ResourceId Field

ResourceName  Field(s)  ---   Displays in column or row Headers for the Resource.(Can be Expression, Local variable, built in an embed, etc. )

The Appointment(Schedule) File Needs to store the ResourceId mentioned in the above file, and Retrieves the Listbox Display name from that information and ties the files together.  Three Keys are required, a ResourceId-date-time Key, Date-Time Key, and SysId Key for update options.  Minimum Fields consist of the SysId, ResourceId, Date, Time, Duration, and the Schedule Display.  The Schedule Display is what shows up in the Listbox for the Scheduled appointment, and you can fill it from a customer file, and/or other files, or freehand other entries such as Lunch, Vacation, Business Meeting, etc.  This should be a required field also.

You can also add the optional GuiId Field/Key for remembering settings in the RecurSched template.

Date keys used in the Template need to be in ascending order or the template will not work with the file.

Appointment(Schedule) File

SysId --  Autoinc Key (for update options)

ResourceId--Date--Time  Key

Date--Time  Key

SysId Field, long,Autoinc

Date Field

Time Field

Duration Field

ResourceId Field --- To tie to Unique Field in Resource File

SchedDisplay --- Field that displays in the Appointment Field in the Listbo

GuiId Field/Key - For remembering recurring appointments settings*

*the GuiId Field/Key is optional.

For your convenience, a BSTTxd directory under the Example File contains 7 example .txd files with the idents removed so you can safely add one or more of them to your dictionary for use with the templates.

ApptLong.txd --  Longer Version of an Appointment File

ApptShort.txd -- minimum Appointment file information

Project.txd --  Sample Project File

Reminder.txd -- Sample Reminder File for Wall Calendar

Tasks.txd -- Sample Tasks File

Rsch.txd -- Sample file to remember settings in the templates that use RecurSched

BSTDemo.txd -- all files used in the Example/demo

Add fields to the .txd files as needed.