UNION OF TABLES

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

[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