Stored Multi Field Finds - Simulated in a Filtered Portal with Paging [Beta-8.5] - Community Videos, Tips, & Techniques, Articles.

July 18, 200619 yr

Solution / Stored Multi Field Finds - Simulated in a Filtered Portal with Paging

Description: User can store unlimited number of Finds, recall by selecting from a Portal.

Additional Fields can be setup and need a global field and a unstored calculation each.

Functionality can be easy transferred to other Tables

NO Custom Function, uses new List(field) function. NO loops and extra Layouts required.

Uses a filtered portal to show the “found” records, relationship can also be used with GTRR Script step in Layout List form for e.g. printing.

Stored Find string principally can be used in a Navigation system with BACK Buttons! (not included).

Records can be omitted from the “found” set.

The shown Principe could be used for a complete dynamic find - constrain - omit simulation of the present FileMaker FIND which is not dynamic.

Constrain Found Set by adding ID ValueLists to the PortalKey Field.

Omit Records by adding ID ValueLists to the OmitKey Field.

Any feedback, error reports, and suggestions welcome - can for sure be optimised more ;-)

Working Under: 8.5

Solution Status: Beta

Pre-requisites: Sample needs FileMaker 8.5 minimum.

Author(s): Ohgo_Ohgo

Date: 07/17/06

Credits:

Instructions / Other Info:

Disclaimer:

FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify.

StoredMultiFindPortal_V1.zip

Edited July 18, 200619 yr by Guest
new version v1.1