StrataFrame Forum

Parent Table Field

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

By fookyean - 6/13/2006

How to display the parent table field in BrowseDialog form ? for example, an invoice that include the customer name in BrowseDialog and allows for searching and sorting.



Another question is how to include the parent table field in the maintenance form and listview ? For example, an invoice that include the customer credit limit in the form.
By StrataFrame Team - 6/14/2006

When you display records within the ListView, you can create a join between the child records and the parent records.  When you set the PopulationDataSourceSettings on the business object, simply type in the name of the joined fields when adding a new "Display Field" and it will be added to the list (it does not have to exist as a property on the business object itself).

As for the BrowseDialog, you cannot add parent fields to the list results themselves, but if you create a BrowseInformationPanel, you can show any additional information within the panel. 

By Michael Wong - 6/15/2006

Besides display the parent field value in the list , is that possible to allows user to search/filter by parent field value in BrowseDialog ? For example, Browse invoice able to search by cusomer code and customer name.
By Trent L. Taylor - 6/16/2006

The browse dialog is primarily used to search a single entity.  However, you can associate a business object with a view which would give you this type of flexibility since it can span multiple tables.  But as of now, the BrowseDialog is really geared for searching a single business object.

If you want to show information associated with another business object within the same browse, look at the sample in the "Samples and Solutions" are of the forum on from the main page.  There is a sample that shows how to use an InformationPanel within the browse dialog which ultimately allows you to do anything you want.