filtering dropdown list based on contact id

[shawnj985]

I have a layout in my email address table which has a contact id field and Contact full name that displays based on a lookup. The problem is when I click on the contact id field the drop down lists all of my 100K+ records. I would like to filter this dropdown list since not all of my records have a full name given.

I would like to filter only on those records with a full name entered but not sure how.

NOTE: The contact id field on the layout is set as a dropdown list and currently get the data from the contactid field in the table.

[bcooney]

You could create a calc field in contacts that results in the contact id if the contact full name is not empty. Then use this calc id for the value list source.

[shawnj985]

Thanks. it worked.

[shawnj985]

Oops, I thought it did.

This is the calc for the field but its not working too good.

If ( not IsEmpty ( wps_contacts::Last Name) ; wps_contacts::ContactID & " " & wps_contacts::First Name & " " & wps_contacts::Middle Name & " " & wps_contacts::Last Name & ", " & wps_contacts::Company)

NOTE: What I hope to do is check to see if the Last Name field is empty and if not, concantenate 5 fields to be used as a source for value list. If it is empty, don't display.

[Ender]

If you're likely to have more than a one or two hundred values in your value list, it may be better to use a selection portal. A button on the portal row can be used to grab the ID and set it in the record.

In either case, the related set can be filtered by more than one criteria. For example, you can have a globally stored checkbox to toggle whether or not incomplete names are shown. But you can also filter the list by a partial entry of the name, or by the Status, or by the Address, or whatever.

[shawnj985]

Thanks. Currently, my list is 100+ as far as records.

Is there a sample file you can recommend as to how to do this?

[bcooney]

Here's a simple example of a popup selection using a new window in list view.

I've added the full name flag to the relationship just to illustrate how you can filter the values in the list view by jumping thru a relationship with a gttr script step. I've used a global constant calc field in Forms to match the flag field in Contacts.

Another approach is to have the popup window contain a portal. Then you could have portal filters to help a user narrow down the list. If you a list view, you could very well let the user find to narrow the list.

PopupSelection.fp7.zip

[shawnj985]

Thanks again. I will look at it.

[shawnj985]

That was very nice of you to create that just for me. A big thanks.

[bcooney]

you're very welcome. Now we can look at this together, if necessary, and see how it would apply to your database.