Hi,

I have table relationship as below

In TableB maintenance form, I need to allow user to search tableB records based on fields in TableA, and also field in TableB.

What would you recommend, using two different browsedialog?

Thank you

You could create a view and base a BO off of a view which would allow you to search accross tables.  In the next update, the BrowseDialog has an event (AfterBrowse) that you could then perform another query on a different BO that is used for editing.  I am sure the next question is when will we post this....it will probably be two to three weeks before we post the update.  Another option is to use a BrowseInformationPanel which would allow you to perform some additional tasks.  There is a sample that shows how to use the BrowseInformationPanel that comes with the framework.

Hi
>>You could create a view and base a BO off of a view which would allow you to search accross tables.

How to map BO to view? As I see BOMapper only show tables rather than view.

>>In the next update, the BrowseDialog has an event (AfterBrowse) that you could then perform another query on a different BO that is used for editing.  I am sure the next question is when will we post this....it will probably be two to three weeks before we post the update.  Another option is to use a BrowseInformationPanel which would allow you to perform some additional tasks.  There is a sample that shows how to use the BrowseInformationPanel that comes with the framework

Hmm... actually user need to search any records in tableB that has relationship with TableA. At the same time, he might also only search records based on field in TableB

Thank you

Hi Chan,

As far as views are concerned they are listed under the tables in the BO Mapper (at least they are in my system - I use SQL Server as the data source).

Cheers, Peter