THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
Database JGDBFULL Query Set
PROCEDURE 78: FLLWWORKLISTBYARCHV#
The query returns a list of Frank Lloyd Wright Commission Titles ordered by the Frank Lloyd Wright Archives inventory number.
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 FLLWWORKLISTBYARCHV# calls on Table MMTFDRAWINGS FILE to produce a list sorted on Column[COCOMMENTS]; column entries contain a unique identifer that is the Frank Lloyd Wright Archives project number assignment (Note: The inventory sequence is defined by the last two digits of a year, followed by the numerical sequence assigned to a given project within the year; e.g. the fourth project in the year 1945 would be "4504"). The report format sequences the projects from 1902 to 1959, then shows projects from 1885 to 1899.
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
Report Format
Document: Dataease Procedure Definition Printout (PDF)