many to many relationship

[victora]

Hello all:
I have a main table that i attached to a history table. My main table(Claims) can have several lines and it contains Claim#, Membr#, Service_Date and Payment_Amnt.

Now I have to compate this to a history table that has also, several records for a single member. (fields are: member#, Plan_Cd, Start_Effective_Date, Termination_Date). So if a member change plan, a record will be created. If its active the current record Termination_Date = 12/31/9999.

Heres my question. How can I print a report that shows payments made after a member has been terminated? How do I express that in a formula? The tricky part is, if there is a gap in the membership, and during that time, a service was provided. My company wants to recover those $$$.

thank you

 

[Madawc]

If there's some subtle trick to make 'many-to-many' relationships work in Crystal, I'd be interested to learn it.

Assuming there isn't, I'd suggest a separate report to show history items with no main table entry. You could do it as a subreport, of course, and make it look like the main report. To a business user it would all look the same. Madawc Williams
East Anglia
Great Britain

 

[Ngolem]

This is a job for a subreport...not direct table linking.

I still am not 100% clear as to what you want to do....a numeric example would help....but many to many situations are often easily dealt with subreports since you can break the process down into 2 steps Jim Broadbent