By Tony Diaz
The Genre data is already arranged like this:
Genre::ID (Unique Key)
The Platform data is 'simple'. ID and Name. But each item could be multiple platforms. (Example #1 vs. Example #2)
An item can have multiple Genre Categories related to it, and those usually have a single choice from within their Category, but might have multiples.
It's supporting the possible multiples that I'm trying to work out. At this point there's 15 possible Genre Categories that each Item could have a selection from. Most have 4-6 of them.
Example 1: Items::Table on the left, Genre::Table on the right, with some Genre Categories (Genre, Perspective, Pacing, Gameplay, Interface, Setting) and their sub-options.
This one has just one sub-option per category.
Example 2: The Gameplay Genre Category has two sub-options related to it.
Example Genre Table content:
Just cracking the surface on One to One and One to Many relationships, I don't think this scenario is quite covered this way.
Would each of those Genre Categories be portals showing only their related category ID?
I presume that I would add fields to the Items::Table so I can pull related records:
But those only support one relationship.
Would I make value lists from those Genre Categories and Platforms and set them as tick box fields?
By Randy Bennett
Yes, I did say iPhone 5 -
I have a small database i created that has a few portals on different layouts - Everything works fine on my Mac, fine on my iPhone X, even fine on my iPad mini
However, I need it to also work on an old iPhone 5 and the portal data is just blank - nothing. In fact, I really ONLY need it to work on this old iPhone 5 (This particular database will go to a music festival to be used by several other people and I can't give them my iPhone)
I have another layout with different portals that are working on the iPhone 5 - but not this main screen.
I have made sure that all of my fields are small and inside the portal. - So, I am stuck as to why? BTW - It is Filemaker Go 220.127.116.116 (The latest version that I can install on an iPhone 5)
I'm using this calculation--in a parent table in a field temporarily named 'Temp'--to grab course numbers from the course_number field in a related/child table:
UniqueValues ( List ( ASSIGNMENT_COURSE::Course_Number__lxt ) )
(I'm using this calc because the child table contains multiple records with the same course number; it's not a key field.)
My intent is to use six buttons--in the parent table--where each button would grab an assigned row's value using the calculation above. For example, say that the above calc has this result:
I want Button 1 to grab AST-100; Button 2 to grab EDU-100; Button 3 to grab EDU-300, etc.
Mind you, I can't make a value list out of Temp because it can't be indexed.
TIA for your help!