Lougee Posted September 7, 2006 Share Posted September 7, 2006 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. Link to comment Share on other sites More sharing options...
comment Posted September 7, 2006 Share Posted September 7, 2006 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. Link to comment Share on other sites More sharing options...
Lougee Posted September 7, 2006 Author Share Posted September 7, 2006 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. Link to comment Share on other sites More sharing options...
comment Posted September 7, 2006 Share Posted September 7, 2006 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. Link to comment Share on other sites More sharing options...
Lougee Posted September 8, 2006 Author Share Posted September 8, 2006 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6567 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now