Log in to create and rate content, and to follow, bookmark, and share content with other members. Not a member? Join Now!

AnsweredAssumed Answered

Create a list view inside an unrelated form view.

Question asked by sditn on Oct 18, 2017
Latest reply on Jan 9, 2018 by philmodjunk

Like • Show 0 Likes0
Comment • 9

Hello peeps, a quick question please while I wait for my "Learn FileMaker Pro 16: The Comprehensive Guide to Building Custom Databases" to arrive tomorrow (I hope that's good!)

I am an FM newbie, coming from many years MS Access development. Loving FM right now but lack of experience means I am cutting my teeth on the basics.

See below dashboard which has no underlying data (it is just part of the GUI so is linked to a table with no data in it).

I have made a list of records, recipes, now I just want to present it like so. Can I do that?

Thanks in advance!

No one else has this question

Outcomes

9 Replies

bigtom Oct 18, 2017 2:36 PM
Mark Correct
Correct Answer
This can be done. Can work a couple of ways.

You would need a portal. You can do this with an xJoin relationship to your data table. You could also use a global field in the dashboard table related to the primary key of the data table. This is helpful for quickly filter the listed results. The global would work as a multi key field.
1 person found this helpful
Like • Show 1 Like1
Actions
sditn Oct 18, 2017 2:44 PM
Mark Correct
Correct Answer
Many thanks bigtom, I shall take a look tomorrow probably.
Like • Show 0 Likes0
Actions
ch0c0halic Oct 18, 2017 2:45 PM
Mark Correct
Correct Answer
Yes you can.

In FMP language:
The box with the list would be a "Portal". This is required because the buttons are on the side in a list. If you put them in the layout "Header" part at the top you could use a list display of the layout.

However, the portal gives you a benefit that makes it a better choice.
You would need a 'Global" (refers to the type of field storage) field possibly named "Select_recipe_type" at the top in the 'Header' layout part (where the word "Dashboard" is located. The global field would be set up in a relationship to the Recipe's type. So you can select All, Deserts, MainMeal, Appetizers, . . . etc. to show only the desired recipes.

A relationship is set up in the Define Database ad is a link between a field in one Table Occurrence (TO) to a field in another TO.

If you have a table:     Globals
With a field:          Select_recipe_type

And the table:          Recipes
With a field:          recipe_type_calc //This is a calculation: "All" & ¶ & recipe_type to make the "All" selection to work.

You would connect these two field by dragging one of the fields in its TO onto the other field in its TO in the Relationship Graph.

This may be confusing until you understand the FMP language. But once you know what the words mean I think it will be much clearer.
2 people found this helpful
Like • Show 1 Like1
Actions
sditn @ ch0c0halic on Oct 18, 2017 3:21 PM
Mark Correct
Correct Answer
Many thanks and I am really very grateful for your help, this is where we are now, it works. I have not got the 'All' working yet but will look at that tomorrow.
Like • Show 0 Likes0
Actions
sditn Oct 19, 2017 12:23 PM
Mark Correct
Correct Answer
One more request if I can please, I can't figure out how to get 'All' working so that all records are shown if nothing else is in the combo box. I see you have referred to this above. Please see my snip below of the actual code I have, I assume we need something like:

if recipe::recipe_type = "All" then dashboard::select_recipe_type = * else recipe::recipe_type = dashboard::select_recipe_type
Like • Show 0 Likes0
Actions
sditn Jan 9, 2018 10:02 AM
Mark Correct
Correct Answer
Hi,

I just wanted to bump this old one up, can anyone point me in the right direction for getting my "All" to work?

Many thanks.
Like • Show 0 Likes0
Actions
philmodjunk Jan 9, 2018 10:09 AM
Mark Correct
Correct Answer
Dashboard::Select_Recipe_Type = "ALL" Or
Dashboard::Select_Recipe_Type = recipe::recipe_type

If you want all records to show if the Dashboard::Select_Recipe_Type field is empty, use:

IsEmpty ( Dashboard::Select_Recipe_Type ) Or
Dashboard::Select_Recipe_Type = recipe::recipe_type
Like • Show 0 Likes0
Actions
sditn @ philmodjunk on Jan 9, 2018 10:25 AM
Mark Correct
Correct Answer
Many thanks for the quick reply but I am having the same issue, in either example you gave, data is only shown when there is a matching recipe_type. To be clear, all is meant to be a wildcard and does not match a recipe_type.
Like • Show 0 Likes0
Actions
philmodjunk Jan 9, 2018 10:47 AM
Mark Correct
Correct Answer
Either method assumes a Cartesian Join. Do you have that?

In FileMaker, you set this up by changing the default = operator to X. This can be done by double clicking the relationship line linking the two table occurrences in your relationships graph.
Like • Show 0 Likes0
Actions

Create a list view inside an unrelated form view.

Outcomes

Related Content

Recommended Content