Monday, December 22, 2008

FILEMAKER: Don’t Forget You Can Start Your Portal At A Row Other The The First

From Dwayne Wright - Certified FileMaker 9 Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright

CHAPTER 01: The Basics

As you know, a portal is designed to give you a mini list view of records related to the current record you are browsing. You can add a vertical scroll bar to view an almost unlimited number of related records. In some cases, you might have a limited amount of horizontal data to show the user and in a case like this, you can setup dueling portals. For example, one portal can show you related records 1 through 18 and the second portal (using the same relationship and fields can show you records 19 through 36.

Here you can see the dialog box setup for the second portal row.

Here you can see the staff layout from my InBizness product and we are looking at the portals that show the media file records that are associated with that staff member record.

Now the FileMaker 9 feature of auto resizing can goof you up a little here. If you have portal auto resizing setup, your first portal will dynamically show you more than the 18 records when the window is expanded. So you will see duplicate records in the second portals and unfortunately, I don’t have a resolution for that.

If you have any ideas or comments, please feel free to send them my way and I’ll update this blog post accordingly!
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.