Custom relationships


Author
Message
Ben Kim
Ben Kim
StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 reputation)StrataFrame User (207 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

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