I have a document for my band with two forms. The Concert form contains a record for each concert we do with fields for date, time, and location. The SongBook form contains a record for each of the songs we can play with fields for song, key, lead singer. In addition, the Concerts form has a “link to” field with SongBook as the linked form, inverse on linked form selected, and a many to many relationship. (A concert can have many songs, and a song can be played at many concerts.) This works fine. In Concerts, for each concert, I can see the songs played, and in SongBook, for each song, I can see the concerts at which we played it.
In the Concert form, I created a calculation field and selected from the list of fields, song from the Songbook form. It appears as [COUNT::SongBook::Song]. It works fine and I can use this in a filter.
In the SongBook form, I created a calculation field and selected from the list of fields, location from the Concerts form. It appears as [COUNT::Concerts::Location]. However, this is 0 in every song record. So it doesn’t work for a filter. For example, I’d like to see how many songs have been played at 5 or more concerts.
If I create a “link to” field in the songbook form with Concerts as the linked form, then it works.
Does this only work on the “link to” side?
Since a calculation field didn’t work, I used a script field instead and that worked.
-
This reply was modified 3 weeks, 5 days ago by
Harry.
-
This reply was modified 3 weeks, 5 days ago by Harry.
I’m glad you found a solution using scripts.
.
