Page 1 of 1
UNION OF TABLES
Posted: Wed Jun 20, 2001 9:31 am
by Bob_Powell_(Guest)
Is there a way to create an XBASE R&R report that pulls data from the UNION of two tables having the same data structure?
=> RE: UNION OF TABLES
Posted: Thu Jun 21, 2001 7:51 am
by kfleming
Yes.____Use the one record RRMSCAN that ships with R&R 9 and use it to build 2 scan relations to your tables using BRANCH1 (whose value is the character 1) as the linking field and a flexlink scan relation to each table using "1" as the flexlink index key expression).____You then have a multiple scan relationship structure that you can use to print all of the records from each scanned file.____Kathleen__R&R Support