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?

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.

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.

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.