THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
Database JGDBFULL Query Set

PROCEDURE 52: TFDRAWAUTHORBYLAST

The query returns
the authorship of individual drawings for Frank Lloyd Wright commissions, grouping them by principal delineator.

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 TFDRAWAUTHORBYLAST calls on records of Tables AuthorLineItems, MMTFDRAWINGS FILE, and Drawings Line Items to select drawings for Frank Lloyd Wright commissions. The report format produced a list showing Frank Lloyd Wright project number and drawing inventory, client name and project title, grouped alphabetically by the last name of the principal creator, with a total count per group.

The query structure is similar to PROCEDURE 54: TFDRAWAUTHORBYDRAFT of Database JGDBFULL. This query was further developed at a later date for PROCEDURE 11: TFDRAWAUTHORBYLAST in Database JGDB10.

Database Search

Search based on this procedure can be executed through the version of the database available on the website.

  • Search Database

ORIGINAL DATAEASE PROCEDURE SCREENS

Query Structure

JGDBFULL Procedure 52 query image

Report Format

JGDBFULL Procedure 52 report image 

Document: Dataease Procedure Definition Printout (PDF)