Page 1 of 1
R&R Win Xbase 8.1 Table Join?
Posted: Mon Sep 16, 2002 4:05 pm
by 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
=> RE: R&R Win Xbase 8.1 Table Join?
Posted: Mon Sep 16, 2002 8:26 pm
by 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