1 / 9

Relate Command

Relate Command. Same as JOIN- all primary Used to establish relationship between 2 or more tables (up to 18 active relationships) No need to write results to another table Tables remain independent Requires less disk space. Relate Requirements. All tables within same ACL project

thu
Download Presentation

Relate Command

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Relate Command • Same as JOIN- all primary • Used to establish relationship between 2 or more tables (up to 18 active relationships) • No need to write results to another table • Tables remain independent • Requires less disk space

  2. Relate Requirements • All tables within same ACL project • Tables must have common key fields • Key fields must be same data type • Case/justification should be the same • Length not required to be the same, but know your data (works if primary longer) • Be aware of limitations of duplicates

  3. Planning Relationships • Determine the objective- what results are you looking for? • Identify the two tables to be related • Identify the key field common to both tables • Examine key fields in both tables to ensure same length, type & structure • Identify parent table

  4. Planning Relationships Can have direct relations

  5. Planning Relationships as well as indirect relations *

  6. Planning Relationships Also allows multiple relations (up to 18) *

  7. Best Practices for Relations

  8. Adding/Editing/Deleting Relations • The parent table is always identified by arrows pointing to child table • Files can not be JOINED if a relation exists • Before deleting relations, child fields need to be removed from all views of parent table

  9. Creating New Views • Fields from the child table(s) can be added to the parent table for comparison • Expressions can be built based on the parent and child tables • Results can be extracted or exported • If extract record, relate is retained • If extract fields, the relate is lost and only the requested fields remain in the new table

More Related