change relationship but keep field

[rdhaden]

I think the answer is "no", but is it possible to select multiple related fields on a layout (all the same relationship), change the relationship, but keep the fields?

I have several related files, each having the same fields (Baseball::Notes 1 through Baseball::Notes 37; Basketball::Notes 1 through Basketball::Notes 37). I would like to go to the Baseball layout, copy the 37 Notes, paste them onto the Basketball layout, and change in one fell swoop the relationship for all of the pasted fields from Baseball to Basketball. Not possible, is it? I have 37 Notes for each of 18 sports. I would like not to have to change the relationship and specify the field 666 times.

[danjacoby]

Unfortunately, since the relationship is part of the field name, you're pretty much hosed.

Or perhaps that's what happens when you need 666?

[rdhaden]

It seems like it would be a useful thing to be able to do, particularly for self-join relationships where the fields would all remain the same. Oh well. If the problem is the 666, I guess I could always tell Track & Field they're out of luck, then I'd only have 629... Thanks for responding!

[Thom]

Is there a reason you don't show the notes through a portal? You could show 37 rows. Then you'd only have to change the relationship for the portal and the note field on each layout. That's 36 changes vs. 600+.

[rdhaden]

Short answer: Yes, there's a reason.

Long answer: I have a calendar made of 37 portals(relationship CalendarDate=EventDate), one for each day, that, if the user selects "All Events" shows all sports events, home and away, on one calendar. If the user selects "Basketball" it shows only basketball events, etc.

However, the user wanted another calendar onto which they could type their own notes (actually the practice schedules for each sport.) Therefore, my one calendar layout turned into 19 calendar layouts, the original master plus 18 practice calendars. The Basketball::Notes 1....Notes 37 are text fields, each overlaid onto a day on the calendar. So the end product for each sport is a calendar that shows only that sports events and overwhich they can type in the practice schedules for each day.

If you want to talk about a pain in the butt, there are 23 sports in total (only 18 for which they track practices), they want each sport to appear in its own color, and home events are bold while away events are italic. To accomplish this text formatting, each event has 46 name calculations (mBBHomeName=Case(Sport="Basketball,Men's" and HomeAway="Home", Sport & " v. " & Opponent, ""). On each layout, all of these names are overlaid on each other, but only one is not empty for each event. So not only do I have the 666 changes just for the practice text fields, I have 46X37 changes for each of 19 calendars=1,702 times to change relationship and field name. In addition to the 666.

So that's a grand total of 2,368 times. My brain is slowly turning into, uh, whatchacallit, uh, mush.