Category: Design
Syntax: TableNames ( fileName ) |
Parameters:
fileNameA string or text expression that represents the name of an open file.
Data type returned: Text
Description:
Returns a carriage returndelimited list of table occurrence names from the specified file.
Note that TableNames() returns the names of table occurrences from the Relationships Graph, not the actual data tables. A database table may appear in the Relationships Graph more than once.
The list returned by the TableNames() function is ordered alphabetically.
Examples:
Function | Results |
---|---|
TableNames (Get (FileName)) | Would return a list of table occurrence names for the current file that might look like this: |
Contacts | |
Contact2 | |
Invoice Lines | |
Invoices |
: 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