StrataFrame Forum

Browse by link table

http://forum.strataframe.net/Topic7962.aspx

By Chan - 4/6/2007

Hi,

I have table relationship as below

TableA -> TableM <- TableB
1        :     M       :     1

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

By Trent L. Taylor - 4/7/2007

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.
By Chan - 4/7/2007

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
By Peter Jones - 4/7/2007

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