This selection is based on a higher file in the ACCESS list

[d.heasman@mgn.co.uk]

Because the "Select filename" construct is a function to select the file in
 particular not the record complex.
 If you just say
Select if AID of SARTYPE-DATA = "Y"

 you'll be OK.

Dave




"Charles Lewis" <lewisc@swau.edu> on 28/01/99 15:21:37

To:   powerh-l@lists.swau.edu
cc:    (bcc: David Heasman/IT/CW/MG_CW)
Subject:  This selection is based on a higher file in the ACCESS list




Why can't you select a record structure given criteria in it is linked to?

Example:

Access *IDNUMS link to TRANSACTION-DATA link to SARTYPE-DATA
Select TRANSACTION-DATA if AID of SARTYPE-DATA = "Y"

I need to be able to report every record from IDNUMS and include any aid
transactions (if they exist). What is the workaround? Do I have to create
yet
another subfile?

====================================
Charles Lewis
Director of Administrative Computer Services
Southwestern Adventist University
PO Box 567
Keene, TX 76059

Phone: (817) 645-3921 #220
Fax: (817) 556-4744
Email: lewisc@swau.edu
====================================


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.




= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.