THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET

PROCEDURE 47: PUBDRAWLIST

The query returns a list containing bibliographic citations for all published drawings of Frank Lloyd Wright commissions recorded in the database.

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 PUBDRAWLIST calls on Tables Published/Drawings and Published Line Items to sort published drawings by Frank Lloyd Wright Archives inventory number and collate project and bibliographic information. The report format produced a block layout of entries containing Frank Lloyd Wright project and drawing inventory numbers, client name, project title, drawing descripton, and bibliographic citation for a publication where the drawing appears, grouped alphabetically by project title. The last generation of the report contained 6,189 entries.

The query structure is similar to PROCEDURE 113: JGPUBDRAWSORTCLIENT in Database JDBGB10, and PROCEDURE 110: PUBDRAWLIST in Database JGDBFULL.

ORIGINAL DATAEASE PROCEDURE SCREENS

Query Structure

JGDB10 Procedure 47 query image

Report Format

JGDB10 Procedure 47 report form

Document: Dataease Procedure Definition Printout (PDF)