Merging Two Sesame Applications

This option is found under "Application Utilities", only in the Menu Tree style view of Sesame’s main Command Window, and not in the Command Button style view. You can restore Sesame to Tree style menus by adding the following line to your sesame.ini file: MENU STYLE: TREE

Always backup your applications before performing a merge operation!

While Sesame can contain multiple databases, they do not all have to be designed/added to the application in a single session. You can start with a simple one-database application, and work with it for a while, adding records to it and so forth; later, you can design a second application with its own database(s), and add new records to it as well. When you are happy with both/all applications, you can combine them into a single application using the Merge Application feature. You can also merge an application with multiple databases into another application. All of its databases will be merged with the current/target application. Merging Two Applications
Merging two applications - where the databases in each application are related in some way - gives you certain advantages over using the databases in separate applications. For example, you can place a subform on a form if the database for the subform is in the same application as the form. (See the section Working with Subforms in the Sesame User Guide.) In addition, external lookups (or XLookups) between databases in the same application are faster and more efficient than between databases in separate applications. (See the XLookup family of commands in the Sesame Programming Guide.) Note: In the two applications to be merged, there cannot be two databases, forms or reports of the same name. If you merge a new application into an existing one where this condition exists, Sesame will append "000" to the object with the matching name that is being merged. The process for merging two applications :

1. Open the first application
2. Select Application Utilities / Merge Application
3. When the Select Application dialog displays, click on the filename of the second application to be merged with the currently opened one
4. Click on Accept

Sesame merges the 2^nd application into the currently opened application. All databases, forms, reports, and data are added to the 1^st application. That is, each database involved in the merge retains its own pre-merge design and data. The new combined application is now a single application with multiple databases.

When merging applications, the existing security on the target/open application will prevail, but security for merged applications should always be reviewed.