THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
Database JGDBFULL Query Set

PROCEDURE 128: PUBDRAWEXPORT

The query returns a list of correlations between Frank Lloyd Wright Archives project numbers and the unique numerical identifiers assigned to related drawings in a table.

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 PUBDRAWEXPORT calls on Table Published/Drawings to collate Frank Lloyd Wright Archives project numbers in Column [COCOMMENTS] with numerical values in Column [PUBDRAWFILE#] representing recorded project drawings. This is a one-to-many relational query. The report format produced a 662 page list showing both numbers within a more elaborate layout void of further information.

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

JGDBFULL Procedure 128 query image

Report Format

JGDBFULL Procedure 128 report image 

Document: Dataease Procedure Definition Printout (PDF)