Custom relationships


Author
Message
Ben Kim
Ben Kim
StrataFrame User (133 reputation)StrataFrame User (133 reputation)StrataFrame User (133 reputation)StrataFrame User (133 reputation)StrataFrame User (133 reputation)StrataFrame User (133 reputation)StrataFrame User (133 reputation)StrataFrame User (133 reputation)StrataFrame User (133 reputation)
Group: Forum Members
Posts: 99, Visits: 253
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 Wink

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

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
In StrataFrames relationship designer can we specify values instead of table fields to define the relationship?  This is an enhancement request I am sure

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

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