This actually IS a ScriptMaker question.

I need to be able to search in a summary field from a related table but when I put the field on my layout, I can't click into it.

The relationship is correct because the field shows the correct results.

I read another thread that suggested scripting a find using Set(field) in a similar instance. OK so far, but I want to be able to modify the find on the fly. Specifically I need to search a field called yearsTotal which is a summary of the years a person has been a club member -- one record in a related table called ActiveYears per year, the relationship is based on contactID on both sides.

So if I script a button to run a find -- using set(yearsTotal), is there a way to input the number of participation years I'm searching for?

This question makes sense to me ; I hope it does to someone else who can point me in the right direction. Or maybe take my hand and walk me all the way through it.

This actually is NOT a ScriptMaker answer. If I understand this correctly, you need to use a local calculation field instead of a related summary.

My apologies if I'm asking the wrong quesitons in the wrong place.

But I can't make a calculation that gives me the information I need.

Guess I'll post a new question in the appropriate forum.

The calculation would probably be:

Sum (related::years)

I don't have enough details to be more specific.

Please do not open another thread with the same problem. If so required, one of the moderators will move this where it belongs.

I was looking at this from the wrong direction. If I use a layout with base table activeYears, sum(partipation) works fine. And, thank you, it's searchable.