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