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, the problem you are having has to do with your view on the save.  Just so you know, we are already going to add the ability in the BrowseDialog to be able to load up a combo box which ties to the foreign key field which would then be a valid search and you would not have to create a view or flat file in order to execute the search.  As for the reason your save is faililng on your view, you can always turn debug mode on your data source to see what is being created and what the values are the parameters are.

In your AppMain.vb or program.cs file, in the SetDataSources() method, add this line of code after the SetConnections() method has been called or after your connections have been added:

MicroFour.StrataFrame.Data.DataBasics.DataSources(0).SetDebugOn("c:\temp\MyDebug.html",True)

Just curious if the combo box population of the BrowseDialog feature had been implemented yet (and if so, where can I find it...).

Thanks!

It is available as we speak and has been since the last update. In fact, the documentation was also updated to reflect all of the changes as well. If you look in the docs under the BrowseDialog control you will see that this functionality exists and it will show you how to use it.

I must be dense...1.5.1 has this? I'm reading through the help topic: Using the Browse Dialog and I'm not seeing this discussion...

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!