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

28 Jan 99 10:35:29 -0500

--=_ORCL_2949123_0_0
Content-Transfer-Encoding:quoted-printable
Content-Type:text/plain; charset="iso-8859-1"

Hi Charles, 

I am probably missing something, but would this work for you? 

Access *IDNUMS link to SARTYPE-DATA optional link to TRANSACTION-DATA
optional 

Select SARTYPE-DATA if SARTYPE_DATA =3D "Y" 

Ron Olenic 
ronolenic@bigfoot.com

--=_ORCL_2949123_0_0
Content-Type:message/rfc822

Date: 28 Jan 99 10:21:37
From:"Charles Lewis" <lewisc@swau.edu>
To:<powerh-l>
Subject:This selection is based on a higher file in the ACCESS list
Return-Path:<powerh-l-owner@lists.swau.edu>
Received:by mail.detroitedison.com with ESMTP id KAA16207; Thu, 28 Jan 1999 10:24:43 -0500 (EST)
Received:by dte.detroitedison.com with ESMTP id KAA15997; Thu, 28 Jan 1999 10:24:42 -0500 (EST)
Received:from sphere.swau.edu (sphere.swau.edu [205.165.192.254]) by cosmic3.swau.edu (8.8.3/8.8.3) with ESMTP id JAA05785; Thu, 28 Jan 1999 09:24:42 -0600
Received:from localhost (daemon@localhost) by sphere.swau.edu (8.9.1/8.9.1) with SMTP id JAA04702; Thu, 28 Jan 1999 09:24:36 -0600
Received:by sphere.swau.edu (bulk_mailer v1.9); Thu, 28 Jan 1999 09:22:48 -0600
Received:(from daemon@localhost) by sphere.swau.edu (8.9.1/8.9.1) id JAA04662 for powerh-l-outgoing; Thu, 28 Jan 1999 09:22:46 -0600
Received:from cosmic3.swau.edu (cosmic3.swau.edu [205.165.192.250]) by sphere.swau.edu (8.9.1/8.9.1) with ESMTP id JAA04657 for <powerh-l@lists.swau.edu>; Thu, 28 Jan 1999 09:22:43 -0600
Received:from tango (tango.ois.swau.edu [205.165.192.199]) by cosmic3.swau.edu (8.8.3/8.8.3) with SMTP id JAA05665 for <powerh-l@lists.swau.edu>; Thu, 28 Jan 1999 09:22:46 -0600
Message-ID:<009501be4ad1$e5bf6aa0$c7c0a5cd@tango.swau.edu>
X-Priority:3
X-MSMail-Priority:Normal
X-MimeOLE:Produced By Microsoft MimeOLE V4.72.3155.0
Sender:owner-powerh-l@sphere.swau.edu
MIME-Version: 1.0
Content-Type:text/plain; charset=iso-8859-1
Content-Transfer-Encoding:7bit

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.

--=_ORCL_2949123_0_0--

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