Getting the Most from Lantica's Sesame Database Manager
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . September 24, 2018  5:01 am. PST


Looking to Upgrade your Q&A Databases?  How to

We expertly convert  

databases of all types

To a variety of data managers



           Spoken here

What's in

This Month's Issue? 

  Lookin' for something?
Three Online Indexes to Inside Sesame
Issue | Keyword/Topic | Subscriber Express

Download the Inside Sesame
Index Database


>>Search Using Adobe Reader<<


Start your development here
(Bells & whistles standard equipment)
Advanced Sesame Applications for Sale



In the Quarterly Do-It-Yourself
Guide to All Things Sesame

  • Maximize your investment in Lantica's
    Sesame Database Manager

  • Get more from Sesame than what comes
    in the box

  • Save time creating the databases and
    features you need (We put in the long hours
    so you don't have to)

  • Get valuable free downloads including ready-to-use Sesame databases

  • Get help with your Sesame questions
    in our regular reader-inspired Help column



Subscribe for one year and receive all
the issues since Vol. 1 No. 1 (2004)
for $149 more ($1 per issue)

More about Inside Sesame

Current Issue

Who we are


Featured Add-ins & Add-0ns
for Sesame Databases

Online demos available on our add-ins
Call for demo and pricing
We can help with installation & set up


We can integrate Google Maps
into any outside service business



The pop-up date-range magician
for reports and more
Flat out the easiest way to pick any date range












Simple Sesame
Office Calendar






A handy dandy integrated office calendar/scheduler

Organize your office and yourself
Pops  up in any form or runs standalone
Supports multiple users/schedules
Pick today, tomorrow or any day
Printable schedules/appointments display in




We do it all. . .
Professional database design/programming
Q&A migration ▪ Web site work

Call to discuss your needs
Subscribers get 20% off our usual rates

  • We've seen and done just about everything under the sun with Q&A and Sesame

  • We published The Quick Answer Q&A newsletter from 1992 to 2003 and have published Inside Sesame since 2004

  • Sesame developers come to us for design and programming advice

  • We do Web work, too, including making Sesame data accessible from Web sites
                       (Recent example)



Visit our companion site

Email Marble Publications & Data, Inc.



Design and merge print all kinds of labels
for your Sesame data




                          for Sesame



Real Q&A-Style Crosstab Reports
for your Sesame databases


Broad-view Scheduling Add-ons for Sesame

All samples below can be customized for the database and to meet requirements
(Scroll browser horizontally to see full images)

Comprehensive Service Calendar (Scheduled jobs)

Changes made on this popup scheduler are saved to the underlying Sesame database
5-Day Look-ahead Service Call Calendar
Appointments with addresses are confirms. Hyperlinked addresses show location in Google Maps (see Sample 3)
     Starting date shows scheduled activity for that day plus next four working days (configurable to support weekends)
     Codes in column headings represent count of confirms and total estimated hours
Popup Google Maps pinpoints the day's service locations
Color-coded by service team with embedded map legend. Mouse hover displays appointment time / address
Popup Scheduler by install team with work details
All jobs completed in this example. Color-coded by job type. Embedded popup calendar allows any date to be reviewed
❺ (A) Popup Scheduler for a plumbing company
❺ (B) Popup Scheduler for a law office
Comprehensive customer history
Pops-up from customer's record on demand. Offers both micro and macro view
     Shows complete order/invoice history plus total quantities purchased by product
Customer sales history ranked by total revenue
Trends report. Shows customer's buying patterns, by product, over past 3 years
Product sales trends
From inventory/product record. Any range of years from last 2 to last 10 years. (10-year range shown here)
     Captions below bars shows year and total sales quantity
Custom-formatted lists/reports w/balanced columns
Stacked and Snaking columns (stacked goes across / snaking flows down like a phone book)
      Reports are run by clicking a button. All are designed to print out on standard letter paper


Site design by Tom Marcellus Marble Publications & Data, Inc.