StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Browse by link table

Browse by link table

Chan — Sat, 07 Apr 2007 19:05:23 GMT

Hi,

I have table relationship as below

[quote]TableA -> TableM <- TableB
1 : M : 1[/quote]

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

RE: Browse by link table

Peter Jones — Sat, 07 Apr 2007 19:05:23 GMT

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

RE: Browse by link table

Chan — Sat, 07 Apr 2007 12:25:23 GMT

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

RE: Browse by link table

Trent L. Taylor — Sat, 07 Apr 2007 11:36:15 GMT

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.