THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET

PROCEDURE 98: JGBUILDINGOWNERS

The query returns an alphabetical list of clients, owners, or other relationships with Frank Lloyd Wright buildings.

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 JGBUILDINGOWNERS calls on Table MMTFNL with a filter applied on Column [COCOMMENTS] ("not = blank") to select records that have an assigned Frank Lloyd Wright Archives project number. This relationship allows retrieval of names associated with a Frank Lloyd Wright building, usually a then owner, caretaker, or organizational representative. The report format produced a directory of contact 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

JGDB10 Procedure 98 query image

Report Format

JGDB10 Procedure 98 report form

Document: Dataease Procedure Definition Printout (PDF)