I want to see....
What DO you see???
It's what I don't see. so if a Title has more than one checkbox checked. it will only show up in the report under the first one checked. so in my example, I see this:
TV SHOW 1
Also - I have a Genre Count summary.
If one of my titles has multiple checkboxes set in the genre field, my subsummary genre count becomes flawed and remains blank.
It looks like you have one record with multiple "Genre" values selected in your checkbox field. That, as you've discovered, won't work as your report is trying to list the same record in mutiple locations.
You'll need to set up a related "Genre" table instead of check boxes. Then you can base your summary report on the Genre table and sort by Genre with the titles from your main table displayed in the sub summary parts. Look up "portal" in Filemaker's Help system for a simple method of replacing your check box field with a portal.
whats the point of checkboxes then?
Checkboxes are extremely useful in many ways. I use them in nearly every DB I create. It's just not the best approach in your situation.
so when i create a "Genre" table - what next? does every genre listed in the one checkbox field need to have it's own field in the new table?
i'll read up on portals as well, but any advice is most helpful.
You'll only need two fields in the Genre table:
In your relationships graph link the tables
MainTable::FilmID = GenreTable::FilmID
(FilmID could be your film title, but a serial number field is a better choice.)
Double click this relationship line and enable the "create" and "delete" options on the GenreTable side of the relationship.
Place just the GenreTable::Genre field in your portal and format the field with either a drop down list or pop-up menu of your Genre types.
Then you can assigne Genre types to a movie by selecting each desired genre type in different rows of this portal.
Now you can base your report on the GenreTable instead of your main table, but add the fields from your Main Table to sub-summary parst "sorted by" GenreTable:::FilmID to get the report you want.
thanks for this info. sorry to be so obtuse on this - portals are new to me.
can you clarify this for me when you say: "Place just the GenreTable::Genre field in your portal and format the field with either a drop down list or pop-up menu of your Genre types. Then you can assigne Genre types to a movie by selecting each desired genre type in different rows of this portal."
i'm not following this.
tell me if I'm wrong:
- i add a portal on my layout.
- i then drag the field i currently have containing the genre checkboxes into the portal.
- i then change that field to be a drop down list or a pop-up menu, instead of being checkboxes.
if i do that, i'm not understanding how a user can select more than one genre per title.
Place your portal on your layout. The wizard that pops up will allow you to select GenreTable as the source of record you want for your portal.
It will then list the two fields that are defined in this table. Select Genre as the field you want.
After clicking OK to dismiss the portal, select the Genre table and use Field/Control setup to format it as either a drop down list or a pop up menu--either option works. Specify a value list that lists all your genre types.
Let's say your film is "Toy Story" and you want to assign it to both Children and Fantasy genres:
In the first row of the portal, click on the field and select "Children".
On the second row, click on the same field and select "Fantasy".
it does make sense, except the field is totally blank...
sorry - fixed the blank problem...
let me see what i can do here and if my sort works.
thanks so much.
Keep in mind that you now have to set up your layout so that it refers to the Genre table instead of your main table of film records. Enter layout mode and use Layout Setup... to switch the layout over to GenreTable. You can now set up report like this:
--SubSummary when sorted by GenreTable::Genre
Sort your records by Genre and you'll see what you want.
the entire layout has to refer to the Genre table, not just the subsummary part?
right now - this isn't working.
To use the toy story example - i select Children. great. next row pops up. I select fantasy. it reverts it to Children. so my column looks like this:
I click out of the portal - it all disappears, except for the first row, so it only looks like this:
other than that - everything you've taught me so far is spot on!!!