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?

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)

Thanks!

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.

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.