Parent Table Field


Author
Message
fookyean
fookyean
StrataFrame Beginner (20 reputation)StrataFrame Beginner (20 reputation)StrataFrame Beginner (20 reputation)StrataFrame Beginner (20 reputation)StrataFrame Beginner (20 reputation)StrataFrame Beginner (20 reputation)StrataFrame Beginner (20 reputation)StrataFrame Beginner (20 reputation)StrataFrame Beginner (20 reputation)
Group: Forum Members
Posts: 12, Visits: 49
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.



StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
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. 

Michael Wong
Michael Wong
StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)StrataFrame Beginner (1 reputation)
Group: Forum Members
Posts: 1, Visits: 7
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.
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
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.

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