Linking question

[Deskin, Bob]

Presumably there is a common key or index. Try this:

ACCESS setA LINK TO setB OPTIONAL
SELECT IF NOT RECORD setB EXISTS

This will create a record complex whether SETB exists or not and then select
those that do not have a SETB.

Bob Deskin              
PowerHouse Web Product Manager and Senior Product Advisor
Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA

-----Original Message-----
From: jlkeepers@mmm.com [mailto:jlkeepers@mmm.com]
Sent: February 19, 2001 10:11 AM
To: powerh-l@sphere.swau.edu
Subject: Linking question




Morning all (at least at this part of the world!),

I am wondering what is the best way to link two data sets together so that
the
output file contains records from SET A that are NOT in SET B.  Any ideas
would
be appreciated.

Sincerely,
Jeff Keepers


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
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
This list is closed, thus to post to the list, you must be a subscriber.