Donor Database Repeating Fields

[sobek]

I am creating a donor database in which there will be repeating fields holding a donation date, a donation type, and a donation amount. Later I will need to create reports on what type of donation was given when and how much it was. How do I get these to "stick" to one another? Example: how do I get the information from the third repetition based on a find looking for a specific date? Is this even possible?

[SteveB]

I'll say it before anyone else does. DON'T use repeating fields to accomplish this. While they have their uses, this is not one of them. Instead, create a relationship in another file where you store the donation, date type, etc. Each donation is a separate record.

Steve