Custom relationships

Ben Kim — Thu, 07 Dec 2006 11:48:56 GMT

We have a couple of tables to support various types lookups. Here is the schema:

PolTable: (Header Table)
DepartmentID    TinyInt
TableNumber     Int
Description        Varchar(50)

PolTableD: (Detail/Child records to PolTable)
DepartmentID     TinyInt
TableNumber       Int
LineItem            VarChar(3)
Description         Varchar(50)

The relationship is a one to many:
PolTable.DepartmentID = PolTableD.DepartmentID
PolTable.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

RE: Custom relationships

Trent L. Taylor — Thu, 07 Dec 2006 11:48:56 GMT

[quote]In StrataFrames relationship designer can we specify values instead of table fields to define the relationship? This is an enhancement request I am sure [/quote]

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).

StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Custom relationships

Custom relationships

RE: Custom relationships