Creating report from MDF and DBF

[jefffried]

With Reportworks Infinity (v 12), can you create a report that pulls from MDB (MS Access) and DBF files? There would be key fields in each that would form the basis of building a relationship, so I wonder if, for example, the master file is an MDB file, can a relationship be set up with a DBF file. And vice versa, can a master be a DBF with relationships set up with MDB tables?____I assume if this can be done, it can be done with the SQL version.____If you know the answer, please advise. Thanks.____Jeff Fried

[kfleming]

You would need to create a SQL report against the Access table and export the results to DBF. You can then use the Xbase version to combine the exported DBF with your existing DBF tables.____Kathleen__R&R Support

[Jeff_Fried_(Guest)]

Kathleen,____First, let me express my sorrow on your loss. This is an especially difficult season for this, and I hope you manage your way through it with a minimum of difficulty.____Thank you for your reply. I thought this might be the case, i.e., using the SQL version of R&R to then export Access data to DBF, then to combine with the DBF data.____Jeff Fried