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?