defining find on the fly

[Lougee]

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.

[comment]

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.

[Lougee]

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.

[comment]

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.

[Lougee]

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.