Skip to Content
0
Former Member
Sep 19, 2007 at 08:49 PM

Same data being displayed multiple times

125 Views

Post Author: C Hall

CA Forum: Data Connectivity and SQL

Not sure if this is the correct forum for this question, so please redirect me as appropriate. I'm working with a mortgage program and the report I'm trying to create is displaying the same data, multiple times. Example: where it should show loan id 12345, the next record 12346, 12347, etc along with the buyer name and property, what's actually being displayed is loan id 12345, joe buyer, 123 main st about 20 times, before it shows the next record. All of the data that I'm trying to retrieve is essentially in one table. So, TableA lists the loan id, buyer name, property, closing date, and every other piece of loan information in it except for a couple of fields. There are two other tables that I'm using for my report: TableB and TableC. TableB has just one field that I'm using and I can probably drop that. TableC I had to create myself and has several fields that I do require. TableA and TableC both use Loan_ID as their primary key. Looking at Database Expert > Links, these tables are joined as follows: Inner Join, Not Enforced, equals. I think that this is where my problem lays, but not sure how to fix. I have tried all the other options and they just return an extreme amount of data--all duplicates. Any help would be appreciated.Chris