THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
Database JGDBFULL Query Set
PROCEDURE 89: TFCLIENTLISTBYFILE#
The query returns a list of Frank Lloyd Wright commissions recorded in the database without a decorative arts category.
Note: The column labels shown within the query structures are historical references only, and do not reflect the definitions used within the version of the database being served through the website.
PROCEDURE NOTES
Procedure TFCLIENTLISTBYFILE# calls on Tables MMTFDRAWINGS FILE and Drawings Line Items with a filter applied on Column [DECORATIVE ARTS] of Table DRAWINGS LINE ITEMS to include only blank (e.g., unassigned) entries; see the lookup list in the table for options of category. The report format produced a list ordered by Frank Lloyd Wright Archives project number, with project title and client name.
Database Search
Search based on this procedure cannot be executed through the version of the database available on the website.
ORIGINAL DATAEASE PROCEDURE SCREENS
Query Structure
Report Format
Document: Dataease Procedure Definition Printout (PDF)