PolTable: (Header Table)DepartmentID TinyIntTableNumber IntDescription Varchar(50)
PolTableD: (Detail/Child records to PolTable)DepartmentID TinyIntTableNumber IntLineItem VarChar(3)Description Varchar(50)
The relationship is a one to many:PolTable.DepartmentID = PolTableD.DepartmentIDPolTable.TableNumber = PolTableD.TableNumber
In our entry forms we have several fields on the form that look to PolTableD with the current department (determined at logon) and a hardcoded value for PolTableD.TableNumber.
In StrataFrames relationship designer can we specify values instead of table fields to define the relationship? This is an enhancement request I am sure
If not how can we code it once in the BO so when a BO is used on a form with multiple relationships back to PolTableD using differing TableNumber's it is automatically related for our programmers?
Thanks!
Ben, Emergitech
No. This is why StrataFrame is so extensible and interfaces very well with .NET so you can provide additional functionality outside of the norm. This is more than likely something that will not be added to the framework.
If you are referring to data loading, this is a different issue. You can look at the documentation and all of the intrinsic Fill() methods. Additionally there are controls, such as the BusinessLayerLinkManager that will auto load child tables based on an established relationship (within the control).