Alex,

On #1, thanks for the info on eView. I have downloaded and will hopefully be successful using it.

Sorry for being vague on #3. Basically, they want to be able to do searches by more than just the current field. So, say that it is a vendor #. They want to be able to click a button to search on company, address, city, state, etc. and provide a list that they then select the correct one from. It's like a find process, but just at a field level rather than on a form level. I believe that this type of thing is built into VFE and was wondering if anything like this is built into MM.

Rod

>Hi Rodney,
>
>>1. Need a view that has more than 2 tables, but system won't handle it in the view designer. Is there a way to do this, or do I need to move to 6.1 and use SQL Pass Through? If so, how do I implement SPT?
>
>I'm not experienced with SPT, but as most MM user, have become quite good with views.
>
>Create the views programmatically (i.e. create sql view....) and then use a product such as Erick Moore's eView or ViewEdit (not sure about the name) to set up properties at the field level (i.e. updateability, default values, etc.).
>
>>2. How would I force an edit screen to save the information when clicking on the OK button so that the information isn't buffered?
>
>Whatever bizobj is registered as the primary on the form will save the data as you hit the OK button. If you have more than one bizobj, be sure to set the children to have the primary bizobj as parent and the "save child on save parent" property set to TRUE.
>
>>3. I have a request for an easy lookup method for fields that are currently done as combo boxes. Is there anything within the framework that would allow for this type of field (i.e. field that you can enter in or hit a key and do a flexible lookup process)?
>
>I think combo boxes support incremental searches. Question #3 is not that clear. Would you mind clarifying a bit what you need?
>
>Good luck!
>
>Alx