.NODE

RelationInfo()

Category: Design

Syntax: RelationInfo ( fileName; tableOccurrence )


Parameters:

fileNameA string or text expression representing the name of an open file.

tableOccurrenceA string or text expression representing the name of a particular table occurrence in fileName.

Data type returned: Text

Description:

Returns a list of information about all the table occurrences that are related to the specified tableOccurrence.

The results are formatted as

 FileName
 Related Table Reference::Related Field
 Local Related Field
 Options for "right" side of relationship ("Delete", "Create" and/or "Sorted")


Repeat above four lines for each relationship.

The RelationInfo() function returns four lines for each table occurrence thats related to the one you specify. If there are no options selected on the "right" side of the relationship, the fourth line is blank.

Examples:

RelationInfo (Get(FileName);"Contacts 2") might return values that look like this:

MyDatabase
Invoice_Line::ContactID_fk
ContactID_pk
Delete Sorted
MyDatabase
Phone_Nums::ContactID_fk
ContactID_pk
Delete




: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information

show all menu





FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352
Similar book on Amazon

Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net