R&R Win Xbase 8.1 Table Join?

[Chris_(Guest)]

I want to create a report from data in two separate tables. Neither is a relational table to the other, they both contain "master" data. Is there any way to join the two together in 8.1, or am I due for an upgrade?____Thanks,__Chris

[kfleming]

An upgrade would help in that Version 10 allows you to create indexes on the fly.__The way to sequentially join two tables is to use a third table as the master, build a calculated field as a constant such as the number 1 and then set a scan relation using this calculation to each of the other tables using an index key of that same constant value so that a single record from the master file matches all of the records in each related table. You then have a multiple scan report.____Kathleen__R&R Support