Solved

FM - Filtering a Value List for a Drop-Down Box

Posted on 2010-09-07
9
1,592 Views
Last Modified: 2012-05-10
I have a Notes table where an agent can enter notes based on one of their customers.  The only problem is that the value list that shows in the drop-down box shows ALL customers, not just their own.  This is a problem due to confidentiality, not wanting to share customers, etc.  I could relate the tables in such a way to only show their customer names; however, then this would prevent the customer code from showing in the various portals in different layouts.  You want the customer code (but not the name) so the agent can navigate to the RR.

So, how would you filter a value list by agent (each customer does have an agent assigned to them marked in a field), but not causing the corresponding portal field to be blank?  So far the only solution I can think of is for each agent to keep a record of their customers and cus codes and then only list customer codes (not names) in the drop-down box when the Note is first created.
0
Comment
Question by:rvfowler2
  • 6
  • 3
9 Comments
 
LVL 12

Assisted Solution

by:North2Alaska
North2Alaska earned 500 total points
ID: 33620324
In the Value List description you can have the list display one value and use another.  Check out the graphic.
Value-List-Settings.tiff
0
 
LVL 2

Author Comment

by:rvfowler2
ID: 33620751
I know about the secondary field.  I just tried to limit it by "include only related values starting from" but nothing I chose worked.  What I want is if the agent editing the Notes record is LJ, I only want Contacts to show that have LJ in the "Assigned Agent" field in Contacts.  If the agent editing the Notes record is TD, I only want contacts showing that are TD's contacts, so other agents cannot "steal" each other's contacts.  Contacts are highly confidential among agents.
0
 
LVL 12

Expert Comment

by:North2Alaska
ID: 33620885
It sounds like your relationship is in question.  Is this relationship the X one?
0
 
LVL 2

Author Comment

by:rvfowler2
ID: 33622154
No, see attached images where I show the relationships and the value dialogue box.  I'm 90% of the way there:  it now only shows contacts for a particular buying agent/notes author; however, if a contact has never been assigned a Note yet, it won't show up in the drop-down box.  How can I fix that?
wrc-Relationships2.JPG
RelatedValueIssue.JPG
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 12

Accepted Solution

by:
North2Alaska earned 500 total points
ID: 33622296
OK, I think this is as expected.  You are using the WRC_Notes table as a "Joining" table to WRC_Contact2 and the only way that will work is to have a note entered.

If Contact3 and contact2 are the same table then just join them directly.  Don't be afraid of TO.  Use them as needed.  I find I think of them and relationship as "Stored Queries".  Just a thought...
0
 
LVL 2

Author Comment

by:rvfowler2
ID: 33622473
Just double checked, but that doesn't work, it comes up empty.  I need to relate Contacts to Notes or else how does it know to limit the contacts by the Buying Agent in Notes?
0
 
LVL 2

Author Comment

by:rvfowler2
ID: 33629612
Still have same problem that if I create a new contact, it does not show up in the drop-down list.  Based on the Relationship graph you see above, what can we change to make this happen.
0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 33662710
Played around his suggestion to make it work.
0
 
LVL 2

Author Comment

by:rvfowler2
ID: 34963036
Forgot this as it was used in a seldom-used db and layout.  Turns out North2Alaska was right, but I misunderstood him.  A way of thinking about it is that whatever TO you use for the secondary field, it must be joined to the table you are using for the primary field, NOT to the main table on which your field and value list are used.  The secondary table filters the primary table, so must be connected directly to it.  Still learning....  :)

P.S. - Also, love your concept that TO's are "Stored Queries."  Has really increased my versatility with portals, etc.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video discusses moving either the default database or any database to a new volume.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now