Find request on value list/repeating field

[hillj888]

I have been tracking donations in a set of repeating fields (date, amount of payment, type of campaign, etc)

for the type of campaign i have set up a value list. individuals can donate to more than one campaign so have a lot of folks who have a number of different items in the repeating fields. how do i perform a find request on only one type of campaign without having the other types show up in the found set?

ultimately, i want to be able to do caluculations or summaries on how much money has come in from each different campaign in the value list but when i do a find on people who donated to one of the campaigns it also displays any other campaign they donated to. how can i do a summary only one type of campaign in the value list?

thanks in advance for any help you can provide!

hillary

[Vaughan]

You'll need to dump the repeating fields method and use related records and a portal instead.

Once you use related records EVERYTHING will seem so much easier to do. Summaries, totals, counts, reports. Easy with related records.

[hillj888]

well that was my initial plan--to work w/related fields in a portal but i came up with a problem when i tried to create the value list. i posted to this list and someone told me that what i was trying to do was difficult in version 4 but i don't have an option to upgrade. so i decided to go back to using repeating fields. sigh. i will try to do the portal/related fields thing again and see if i can come up with a way around the value list thing.....

thanks!