X hits on this document

Powerpoint document

Database Management: Tables - page 31 / 35

72 views

0 shares

0 downloads

0 comments

31 / 35

1/23/2015  UT Dallas

POEC 6382 Applied GIS Software

31

Connecting Tables with RELATE

A RELATE temporarily associates data files based on a common item occurring in two files.  

Although a relate is temporary, the association between files can be saved.

Types of relates:

One-to-one relate - the values for the common item are unique in each file being related

Many-to-one relate - many records in the main file may be matched to one record in the related file.  Example: road types, lookup tables

Command RELATE establishes or modifies the relate environment. Up to 100 relates can be stored in a single relate table.

RELATE <ADD|DROP>  add or drop a relate.  Will enter a dialog to specify properties -- see below.        

RELATE <RESTORE | SAVE> <info_file> bring back a relate from a previous session, or save one for a future session

RELATE LIST {relate}   lists properties of either all the relates that are current or just the relate you specify

Document info
Document views72
Page views72
Page last viewedSun Dec 04 15:23:56 UTC 2016
Pages35
Paragraphs787
Words4938

Comments