I have a report which requires data from 2 tables.
Table 1 shows all instances where we have loaned an item to a customer against a repair
Table 2 shows all repairs
I need to return all loan records and details from repair records that have had a loan against them
Loan records contain the associated repair reference and the repair records contain also contain the associate laon reference - therfore giving two different ways to link the records together.
I have tried both methods with an inner join, but the report returns a messgae 'unable to open a rowset' and the Crystal reports crashed and I have to re-start.
There should only be one to one relationship with Loans to Repairs, but there are Repairs that do not an associated loan.
My searchs on various forums indicate that this is possibly due to the way I am linking my tables.
Can anyone confirm if an inner join is the correct type of join to use in this instance? or should I be using a left outer (with the loan table being on the left)