I'll do my best to put my question into words... just not sure how to.



Consider I have a table with these fields



TableName: Employees

EmployeeID

FirstName

LastName

LocationID



Here is an excerpt from the Locations table



LocationID LocationName

1 United States

2 Canada

3 Mexico



Lets say I created a BO based on this Employees table. Now I create a maintenance form based on this Employees BO.



Now I want to create a BrowseDialog. The question I have is when I create the browse dialog how can I display the locationnames and have them be searchable instead of the ID.



I had thought about creating another BO based on a view I would create with the columns i need but I'm not sure how the browsedialog returns results to the BO its filling if the BO its browsing is different than the Primary BO attached to the form.



I hope thats not too confusing.