Free Document - Database Design for FMP

[David Kachel]

FOR IMMEDIATE RELEASE - OCT 24, 2005

DATABASE DESIGN FOR FMP - VERSION 1.01 RELEASE

Salt Lake City, UT--OCTOBER 24, 2005--David Kachel/Codemasters Workshop -- publishers of AutoNavigator for FileMaker Pro--Today announced the first release, version 1.01 of their free DATABASE DESIGN FOR FMP guide.

DATABASE DESIGN FOR FMP is a set of instructions for designing FileMaker Pro™ databases. Every book on FileMaker tells you that you should design your solution before you begin to build it, but newcomers never do because none of those books tell you HOW to design your solution! Now you can. DATABASE DESIGN FOR FMP is a step-by-step guide to designing your database solution in FileMaker Pro™ from start to finish.

Don't put yourself in the position of having to do a complete rewrite of your database because of fundamental design flaws. Get DATABASE DESIGN FOR FMP and learn to design an efficient and robust solution from the start.

DATABASE DESIGN FOR FMP is available for immediate download at: www.codemastersworkshop.com/downloads.html

Publisher:

David Kachel / Codemasters Workshop is the publisher of AutoNavigator for FileMaker Pro. He has

more than 14 years experience in designing and building custom

solutions in FileMaker Pro.

###

© Copyright David Kachel/Codemasters Workshop. FileMaker Pro is a

trademark of FileMaker Inc. All rights reserved.

David Kachel

Codemasters Workshop

email: [email protected]

web site: http://www.codemastersworkshop.com

ICQ: 308137637

Tel: (801) 566-1340, (801) 661-2454

[Jalz]

Hi David,

Thanks for sharing, this is great stuff. I have a small question regarding your earlier paper (White Paper for FMP Novices), dont know if you can help.

I was reading your portal section, and tried to follow your example in creating a portal record, but failed. Is there any chance you can post a very simple demo on your website or in this forum on how to create a portal record, without the use of a portal.

Thanks once again for your contributions.

[David Kachel]

Jalz,

There are lots of ways. You can simply have a script that goes to a layout for the related file, creates a new record and inserts the key field number for the parent record.

Or you can have a duplicate background relationship with "Allow creation of related records" turned on. Have a script get the next ID number for the child record table, plug it into the background relationship and then set any field in the related table to any value, through the background relationship. This will automatically create a record which will appear in the original relationship.

Download "Viewer Table Demo" from our web site for an example of the first option above.

Edited October 24, 2005 by Guest