linking databases unevenly

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Mary_(Guest)
Posts: 9
Joined: Tue Oct 10, 2017 12:44 pm

linking databases unevenly

Post by Mary_(Guest) » Fri Jun 19, 2009 10:31 am

Hi Kathleen,____I believe this was an issue in older versions, and want to know if it is no longer an issue in later versions, or if there is a work around. ____I have a report, created in xbase version 10+ that has several different types of links, and levels. It was working until I added one more level of links to some of the relationships. I cannot get data from the last links added. When I create a simple report, with only the specific links that are not working on the complex report, the links pull the data. ____Here is the structure that existed when I was able to use data from all databases: D = Database______D1 Exact link to D2__D1 Exact link to D3__D1 Exact link to D4__D1 Scan link to D5__ D5 Scan link to D8__ D5 Scan link to D9__ D5 Scan link to D10__D1 Scan link to D6__ D6 Exact link to D11__D1 Scan link to D7____ __I then linked databases 12, 13 and 14. They are all the same database, but are linked with different aliases. The report is not recognizing the relationship between D8 and 12, D9 and D13, and D10 and D14 (although it does in simpler reports). The report still prints the data needed from D1 through D11. Here is the new structure:______D1 Exact link to D2__D1 Exact link to D3__D1 Exact link to D4__D1 Scan link to D5__ D5 Scan link to D8__ D8 Exact link to D12__ D5 Scan link to D9__ D9 Exact link to D13__ D5 Scan link to D10__ D10 Exact link to D114__D1 Scan link to D6__ D6 Exact link to D11__D1 Scan link to D7______Is there anything I can do - add "fake" links to some of the other relationships?____Thanks,____Mary

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: linking databases unevenly

Post by kfleming » Fri Jun 19, 2009 2:26 pm

The problem of uneven scanned grandchildren has not been changed in any later release.____In your case the master has 3 scanned children and only one of those children has scanned grandchildren.____If you can add an equal number of scanned grandchildren to each of the other scanned child tables the report might work correctly but might also be too confusing.____The alternative would be to create separate reports that export data to a single result table (for example the master + plus just the first level scans). That table could then be used as the master file for the next report (so you elimate a layer of complexity in the relation structure.______Kathleen__R&R Support

Post Reply