We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
2 days, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Limiting a pop-up menu to only show records marked "active"
Posted on 2012-12-21
I have a clients table that contains the ID, name, and a active field (0 for inactive, 1 for active).
I want to have a layout where a user selects the active client and then moves on to another layout passing the ID as a variable.
The problem - I can't figure out how to limit the field to only display active clients.
I want to have a layout where a user selects the active client and then moves on to another layout passing the ID as a variable.
The problem - I can't figure out how to limit the field to only display active clients.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
2
7 Comments
Are you displaying the list via a portal? If you are I can suggest two option. 1) either modify the relationship to include the active field or create a new relationship with the same. 2) use portal filtering when defining the portal on the layout.
No, not via portal. It's a pop-up menu to select a client and a day below that and then submit to the next layout, passing those variables. I just can't figure out how to limit the popup menu to only show records marked as active (1).
So, you are using a value list to populate the popup. So, I think a relationship is probably your best bet. Here is a little sample of how you might make this work. The elements to look at are:
1) Global g_active set to 1 (active) to filter the list
2) The Value list uses the "Include only related records" option.
3) The Value List only displays the name but returns the ID. (the g_selected field is only used to capture the selection. You may want or need to do this another way.
4) The Active field is where you would change the status from 1 to 0 to indicate activity.
See if this makes sense...
Popup-Filter.fp7
1) Global g_active set to 1 (active) to filter the list
2) The Value list uses the "Include only related records" option.
3) The Value List only displays the name but returns the ID. (the g_selected field is only used to capture the selection. You may want or need to do this another way.
4) The Active field is where you would change the status from 1 to 0 to indicate activity.
See if this makes sense...
Popup-Filter.fp7
Wow, thanks for the sample database. I see what you did, however I don't understand. I don't see the process that causes the value list to be limited. I can mimic this, but I just don't understand.
It also seems like a lot of work when they could just add filtering formula criteria to the value list generation. But, that is a wish for another day. :-)
It also seems like a lot of work when they could just add filtering formula criteria to the value list generation. But, that is a wish for another day. :-)
Never mind. I see it in the relationship. Now I get it, although it seems like so much work when it could just be a filtered value list. I guess I don't really understand that whole table occurrence thing. I knew i had to do it, but I haven't found a good explanation of them.
Featured Post
![[Webinar] How Hackers Steal Your Credentials](https://filedb.experts-exchange.com/files/public/2017/5/20/3315d9d8-8110-4d52-be94-a5aacdd83e4b.png)
Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Pop up windows can be a useful feature of any Filemaker database. Though best used sparingly, they can be employed in a multitude of different ways, for example; as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?"
An…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Suggested Courses
Course of the Month2 days, 19 hours left to enroll
695 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.