Approach User Support homepage Approach User Support
Answers to Frequently Asked Questions about Lotus Approach
Examples LotusScripts
Example databases
Links to other Lotus Approach support services

[Return to contents]

Maximum of 20 charts per .apr

Last updated: 2 Dec 2000

The following was submitted by and describes a method of getting around the maximum of 20 charts per .apr

Create a subdirectory called MENU. Under MENU create a database called
MENU_1. The database consists of only one field named JOB. Close MENU_1.

Create a database called CHARTS_1. The database consists of only one field
named JOB. Close CHARTS_1.

Open a third database called CHARTS_2. It also contains only one field named
JOB. Close CHARTS_2.

Now, open MENU_1 and join to CHARTS_1 and to CHARTS_2 on JOB. Then join to
your main database file and then to your other database files. Save the
Approach file and close.

Now, re-open CHARTS_1 and create a worksheet, etc. which will generate the
first set of 20 charts from the data in your main database.

Now, re-open CHARTS_2 and create a worksheet which will generate 20 more
charts from the data in your main database.

Now, re-open MENU_1 and create macros to open CHARTS_1 and its associated
charts and CHARTS_2 and its associated charts. If you design the MENU_1 menu
correctly, the user will not realize that you are jumping from CHARTS_1 to
CHARTS_2 to go to various charts.

You can continue to add CHARTS_3, CHARTS_4, etc. for an endless number of

The following was submitted by, and describes a method for getting around the

The trick is to be sure that when you go from MENU_1 to CHARTS_1 that you
create a form with menu choices that will guide the user to the correct
chart. Make the button macros choose which file to go to.

If MENU_1, CHARTS_1, CHARTS_2 are in the same subdirectory, when you create
macro buttons, select the OPEN command and edit the location of the
CHARTS_1.apr as follows: change C:\MENU\CHARTS_1.apr to CHARTS_1.apr. This
allows Approach to operate correctly even if you change drives where the
programs are saved. If you leave the C:\MENU\.... in place, if you save to
D:\ drive and then try to use the macro buttons, the system will tell you
that it cannot find the C:\MENU\.... file.

[Return to contents]

© Copyright, JohnBrown, Trademarks, Disclaimer, Acknowledgements.