Change field on layout by script

[mleiser]

I have a layout that will automatically get a different heading if it's a July report or if it's an August report. Besides that I have two possible portals that will show up in a subsummary. The july portal if it's a july report or the asugust portal if it's an august report. Any idea how to display the proper portal through my script? I know how to get different headings by passing parameters. I can't figure out how to get different portals.

[mz123]

You can use one portal.

I'm guessing the TO for the layout has some field that says "July" right? Use a global field instead. When you go to the layout, allow the user (or use a script) to set the global field to a month and then the related records will show.

[mleiser]

I don't understand. I do pass to the script either "July" or "August". The subsummary has a portal which has info from the relationship "July" or "August", but how do I set the relationship name on the layout to "July" or "August"?

Mike

[comment]

What Martha is saying (and I agree) is that there should be only one relationship, and it should be flexible enough to be switched between July and August (or any other month). This would be done by turning the matchfield on the parent side into a global field, and letting the script set the global field to the required value.

[LaRetta]

Subsummary report with portal based upon related records based upon month/year all seems a bit strange. I would ask for more information ... why isn't the subsummary report being generated in the child table (portal) to begin with? There may be reasons, but I need to ask anyway.

[comment]

I agree, but I was saving this for later. :(

[LaRetta]

Ooops. I should have known you saw it. But it was possible that you were simply very sleepy in the moment. :content:

Edited April 14, 2009 by Guest
Added sleepy comment

[mleiser]

OK. Lets see if I can explain this one. We have a summer camp. Some come for July, some for August, some for all. In short, I have a report that lists campers and their info in different ways. A report is either a listing for July campers (or a subset) or of August campers (or subset). I have a table of campers. I have a second table of counselors, which month they are counselors, which grade they take care of, which room they're in. I have a subsummary on my camper list, (say I'm doing a July list), which has a portal that shows the July counselor, which bunk they take care of(the campers are coming out by bunk on the list)and the room that bunk is in. Same for August lists. In my camper table I have a "July"&bunk field that connects it to the July counselors, etc for the bunk and a "August"&bunk field to connect it for the August info. So currently I have a layout for each moinbths report. I prefer one layout and the July portal should show up for the July report and the August portal for the Aiugust report. Hope this explains it. My fingers hurt. Thanks!

Mike