filtering Value list

[didit]

I have a file of Companies with one field Company ID. In the Companies file I also have a field for Company Type (with three choices, Vendor, Client or ShipTo- check boxes). I have a value list Pop-up in my Purchase Order database to choose from all the Companies, but I want to show in my list only the Companies where the Company type = Vendor. Can I do it?

[danjacoby]

If the pop-up list shows related items only, then you can choose Company Type first, and then the list will only show companies that fit the type.

This works in find mode, too.

[didit]

Thanks for the help. Is there a way to predetermine this without having the user sort of manually limit the list with a selection? Basically I have one Company database with vendors, clients, and ShipTo and I only want vendors to be in this value list always.

[The Bridge]

Following the previous example, define a calculation field, e.g.:

Vendor_Constant = "Vendor"

Then define your relationship from this field to the Company Type. Base your "Vendors Only" value list on this relationship, and only they will be displayed.