I have a stored procedure that has 5 different input parameters, @VendorName, @VendorAddress, @VendorCity, @VendorNumber, and @VendorState. What I am trying to do is much like how dynamic fields are set up. I want to be able to start out with a document that does not have any of the 5 vendor related fields filled in. Sometimes the end user will not know the vendor name, but knows the vendor address, or at least the city. If they click in the city field, and type a city, I want the sproc to run and offer choices for Vendor Name , Address, State ect based on the city they type in. It needs to also work the same way if the user knows the vendor name, but nothing else, then they can start typing in the vendor name in the vendor name field, the sproc runs and returns a list of choices they can select from. I know how to set up dynamic fields using an external table or view but is there any way to do this using the sproc. I've read that you can put the sproc name in the s_name field for the propdef table for the field you want to use it on but so far I have not been able to make that work either. Any ideas out there on how I can do this?