In article
<8585112a-cc4d-40a9-8103-5e2c7b9a86e8@[EMAIL PROTECTED]
>,
loopymonkey <loopymonkey@[EMAIL PROTECTED]
> wrote:
> Hello, I have a drop down menu that lists way too many items right now
> and I want to limit those values listed based on another value in the
> table.
>
> The values in the dropdown are names of projects.
>
> In my projects table there is a value of Open or Closed when a project
> is complete.
>
> I would like my drop down to ONLY show projects that are currently
> open.
>
> It's a little unlcear to me how to get that done.
>
> Any leads help appreciated!
What you need is a Relation****p that will retrieve only the "Open"
records, and then this Relation****p can be used to obtain the data for
the Pop-up Menu's options.
First create a new Global field in the Table with the Pop-up Menu.
eg.
g_Open Global, Text
Put the field tem****arily onto any Layout and type in the word "Open",
and then you can remove the field from the Layout. (Note: If you later
Save As the file using the 'Clone (no records)' option, then the data
in Global fields also disappears, so you will have to re-enter this.)
Next define a new Relation****p that matches this g_Open field with the
appropriate field in the Projects Table (ProjectStatus ?).
eg.
rel_OpenProjects
match records in PopUpTable with records in ProjectsTable
when g_Open = ProjectsTable::ProjectStatus
Then define a Value List that obtains its values from the appropriate
field in the Project Table (ProjectName ?) via this Relation****p.
eg.
vl_OpenProjectNames
values from field, only related, rel_OpenProjects::ProjectName
Lastly format the Pop-up Menu field to use this Value List.
The problem here of course is that such a implementation won't allow
you to Find records for a Closed project since the Closed project names
won't be listed in the Pop-up Menu. There are a couple of ways around
it, but probably the easiest to use a separate Layout where the Pop-up
Menu field still uses the Value List that displays ALL the project
names.
It's strange that so many people call them "drop down" menus and lists?
Maybe it's a Windows difference or a translation difference from
non-English versions, but according to my Mac versions of FileMaker
they are technically called "Pop-up Menus" and "Pop-up Lists".
Helpful Harry
Hopefully helping harassed humans happily handle handiwork hard****ps ;o)
|
