Samples say more to programmers that many pages of arid theory. This samples of little magic application reflect how you can implement correct a relation 1 to N in a correct way on local workstation or in a WEB application. Another sample reflect a sample for Read, Read and Write strategy recommended by MSE in the Reference Manual. I hope that be useful for beginners in Magic and may be the advanced programmers have some sample applications to publish free on Internet like me. I thanks to all magicians that wrote sample and letters in Magic User Group.

I want to thanks to Dominique Stephan for his generosity and for this space on site.

This sample include a program that works with tree files: Number of Headers, Headers and Details. You will see how you can insert, add, delete, modify and renumber details for a headers. File Number of Headers assure a unique number for each header from the Headers file.

This sample include more programs that implement 1 to N relation between two files: Headers and Details. There is too a file with unique numbers for headers. This little application was wrote in Magic 8.3 but after I wrote I see that it can be write in same way in Magic 8.01 and up. I use only Magic (no extern HTML editor, no JAVA cod).

This sample is included in 1 to N (see above). This Magic program reflect how you can print, create, modify, delete records from a accounting plan file in a safe mod on Netware using Read, Read and Write strategy recommended by MSE in Reference Manual.

You can test this program on a virtual net under a Windows 9x operating system even on a standalone PC (without net card or modem).

For that you must set Btrieve to Multiengine and Sharefiles.

Create two directory and copy the same MCF.

Both applications must point to same database files.

Now you launch two instance of Magic, start same applications in both instance, and program Accounting Plan. You can simulate works from two terminals.