This topic is 2570 days old. Please don't post here. Open a new topic instead.
By Richard Carlton
Confused on how you should set up your relationships in FileMaker? In Day 1 of this Livestream, we slowly and methodically cover Claris' officially recommended relational design process, Anchor Buoy! Future live streams: https://fmtraining.tv/#LIVE
I have a calculation field in a portal which shows the value according to ActivePortalRowNumber. Each row has a special determined value.
When I manually enter the value in the field before the calculation field and thereby make a particular row active, my calculation field automatically shows the designated value. Great!
But, if when I do the import from Excel, all data gets nicely imported and the portal shows the imported data but the calculation field is without value. I guess the importing process is not making a portal rows active so the calculation is not working.
Any ideas how this can be solved?
I'm not even sure to describe under which category my specific problems fall into, I can only advance some hypothesys, so I'll just describe it and let the wisdom of others guide me.
I have a DB with several tables, I use them to make invoices. With every invoice I input the desired price and it adds automatically 19% taxes and produces a neat invoice which I can print, these three tables are called:
Now on to my problem. I wanted to create a forth table where from every previously listed table it would calculate the total revenue of the year in question, broke down like this:
- Total Net price paid for 2018
- Taxes for 2018
- Total revenue for 2018 (net+taxes)
- Total Net price paid for 2019
- Taxes for 2019
- Total revenue for 2019 (net+taxes)
- Total Net price paid for 2020
- Taxes for 2020
- Total revenue for 2020 (net+taxes)
I am unsure how to proceed, I tried creating a forth layout and a new table but I have problems brining the summary field from each year's table into the forth table/report/layout.
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?