Download User Reference Guide - MSC Fileman 22.2 Documentation

MSC Fileman 22.2 User Reference Guide
Part 4: Computing Data
Multiples
You can use the simple pointer syntax to get data from Multiples of files
pointed to by other files. The RADIOLOGY EXAM file described above
points to the PATIENT file by way of the EXAMINEE field. In the PATIENT
file there is a DIAGNOSIS Multiple. You could obtain a list of diagnoses
associated with RADIOLOGY EXAM file entries by doing the following:
Select OPTION: PRINT FILE ENTRIES
OUTPUT FROM WHAT FILE: RADIOLOGY EXAM// <Enter>
SORT BY: NAME// <Enter>
START WITH NAME: FIRST// <Enter>
FIRST PRINT FIELD: TEST NUMBER
THEN PRINT FIELD: EXAMINEE:DIAGNOSIS
THEN PRINT FIELD: <Enter>
HEADING: RADIOLOGY EXAM LIST// <Enter>
STORE PRINT LOGIC IN TEMPLATE: Exam Diagnoses
For each entry in the RADIOLOGY EXAM file, EXAMINEE points to an
entry in the PATIENT file. The diagnoses associated with that patient are
returned as the Multiline output of the expression
EXAMINEE:DIAGNOSIS.
Backward Pointer
The following example shows how you can use the cross-referenced
Backward Pointer that yields a Multiline response in an INPUT template:
INPUT TO WHAT FILE: PATIENT
EDIT WHICH FIELD: ALL// NAME
THEN EDIT FIELD: RADIOLOGY EXAM:
By 'RADIOLOGY EXAM', do you mean the RADIOLOGY EXAM File,
pointing via its 'EXAMINEE' Field? YES// <Enter>
WILL TERMINAL USER BE ALLOWED TO SELECT PROPER ENTRY IN
'RADIOLOGY EXAM' FILE? YES// <Enter> (YES)
DO YOU WANT TO PERMIT ADDING A NEW 'RADIOLOGY EXAM' ENTRY? NO//
<Enter>
158
January 2015