Browse by link table


Author
Message
Chan
Chan
Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)
Group: Forum Members
Posts: 533, Visits: 2K
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

Reply
Chan
Chan
Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)
Group: Forum Members
Posts: 533, Visits: 2K
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

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search