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