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 Autoinc SysId key.  Minimum Fields consist of the SysId, ResourceId, Date, Time, Duration, and the Schedule Display. 

The Sched Display(EXPR) 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 in your update form for the file.  You can also assign a Local Variable to this field and build the display line in the TakeRecord Appt Embed.

Add another Field for ToolTip Adds the ToolTip Function to the Scheduler Listbox.  You must supply a Default tool tip to display when it is empty.  ToolTip Display(EXPR) is an expression field that can be built with multi lines by adding "& CHR(10) &" to your expression to add line feeds.  You can also assign a Local Variable to this field and build the display line in the TakeRecord Appt Embed.  You can examine them if empty, and only add the line feed if they contain data, etc for appearances.  This information is stored in the Listbox Queue as a Cstring, and you determine the length you need from 1 -255 in Display Length for ToolTip.

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 Listbox

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

For your convenience, a BSTTxd directory under the Example File contains 6 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.

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)

ResouceName    Key(Optional for Display)

ResourceId Field

ResourceName  Field(s)  ---   Displays in column or row Headers for the Resource.(Can be Expression)

Expression means it can be created at runtime with a code statement such as

CLIP(EMP:FirstName) & ' ' & CLIP(EMP:LastName)

Simply Build the Expression in the Prompt, using the lookup button to gather the field names.

An embed for "Header TakeRecord" is available for further filtering and display construction.

You can create a local variable, assign it to the Sched Display(EXPR) and build to suite in the embed.