Previous Topic: Includes Relation

Next Topic: Relation Sequencing

Examples of Using Includes Relations

You have an Audit stamp structure file that is made up of three components:

FIL Audit stamp STR Has FLD Date DT#

FIL Audit stamp STR Has FLD Time TM#

FIL Audit stamp STR Has FLD User ID CDE

You may wish to refer to the Audit stamp in a number of files.

For instance, a product file:

FIL Product REF Known by FLD Product code CDE

FIL Product REF Has FLD Product name TXT

FIL Product REF Has FLD Product quality QTY

FIL Product REF Includes FIL Audit stamp STR

For instance, an order file:

FIL Order REF Known by FLD Order number CDE

FIL Order REF Has FLD Order status STS

FIL Order REF Includes FIL Audit stamp STR

This would result in the following entries:

 

Product

 

 

Order

K

Product code

Produce name

Product quantity

Date

Time

User ID

 

K

Order number

Order status

Date

Time

User ID