I wanted to explore other options to my previous post about custom fields being searched in the BrowseDialog.

I am using custom fields to display foreign key values from a table. I'd like to be able to search on the textual representation of the foriegn key. For example, say I have a table:

OrderID
OrderDate
SalesPersonID

I created a custom field which grabs the sales person's name (based on the SalesPersonID).  As per my previous post, I was having problems with my logic.

What would be the best way to accomplish this? I've tried setting up a view (this is in Access, BTW) and used the DDK to create the structure.

In the resulting BO, I use a FillAll method which simply fills the datatable using select * from MyView.

The problem I'm having with it, is that I am getting a required parameter is missing error when I try to save a record. I'm assuming it's because of the view.

Any ideas?

Yeah, we actually added this before the last training class.  You can see the help in the StrataFrame Help file under the following location:

UI Layer -> Controls -> BrowseDialog -> Working with the Browse Dialog -> Setting the Search Fields

You will be interested in the section talking about the Combo - Business Object.  There are a bunch of other topics in there as well relating to the BrowseDialog.  The Events may come in handy for you as well since you may need to use the ComboListPopulating event.

Interesting. How do I tell what version of the docs I have? I have the What's New in Version 1.5.1 topic. And I have the UI Layer-->Controls-->Browse Dialog hierarchy of topics. But that's where it stops. No subtopics of Browse Dialog in mine.

Or maybe I just have an older version entirely since my Search Field Criteria dialog has no tabs whatever...will check more deeply after the four-year-old goes to bed tonight.

You may just want to download the latest build from the website.  I am confident that that will get you up to date.  If not let me know and I will see what is going on...but I think it will resolve your problem.

Worked as advertised. Thanks!

Good.  Glad to hear it!