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

[Charles Lewis]

Thanks for your replies so far. I guess I need to be more specific in my
example.

Subfile IDNUMS contains:
    Item STUDENT-IDNUM char*6

File TRANSACTION-DATA contains:
    Item STUDENT-IDNUM char*6
    Item SARTYPE char*4

File SARTYPE-DATA contains:
    Item SARTYPE char*4
    Item AID char*1

I cant just Select if AID of SARTYPE-DATA = "Y", because then it will
eliminate students who don't have aid transactions. I don't want to
eliminate any students in IDNUMS, I just want to only report aid
transactions.

Also I can't put SARTYPE-DATA before TRANSACTION-DATA because it links only
to TRANSACTION-DATA.

Any other ideas? :)

chas

>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?


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.