trying to link two tables

[happydermis]

Hi all,____I have two tables: PPSPLAN & CONTRACT__I would like to have all the information for my report out of PPSPLAN and only the date of shipment should be extracted out of CONTRACT.____My problem is that I can^t find any forign key in CONTRACT that matches a key in PPSPLAN. My problem is that I don^t want to create any new index because I don^t know the system that well (Xbase) and I don^t want to risk any problems...____I hope I am making myself clear enough. Any ideas?____Dekers

[kfleming]

If you are using the Xbase version you do indeed need an index for the related table. R&R allows you to build a flexlink index that should cause no disruption to any existing tables or indexes.____Kathleen__R&R Support

[happydermis]

First thank you for your quick answer!____My boss is fearing this flexindex thing. Do you have any idea to how this method works? I mean - will such index "stays" in the DB after the report is created? Will such index slow down the DB? Will it make the DB bigger?__I believe that if I could show my boss that this method of flexindex is harmless it might make my work much easier...____Any hints?__Thanks, Dekers

[kfleming]

The index will be external to the DBF and will only be updated when the report is run.____Kathleen__R&R Support