Thanks Fedir,
Sure, i will give first example Relation : Field Fixed
I am creating 3 Tables :
- Player
- Footballer
- Cricketer
I am creating 2 BaseEnums :
- PlayerType
- PlayerCategory
Base enum : PlayerType :
Base enum : PlayerCategory :
Table: Player
Fields: PalyerName (String), Player Code(String), Player Type(Base enum)
Base enum: PalyerType : Footballer, Cricketer
Table: Footballer
Fields: FootballerCode (String), Salary(Real), Player Category (Base enum)
Table: Cricketer
Fields: CricketerCode ( String), Salary (Real), Player Category (Base enum)
Now fill some data in to Footballer and Cricketer tables aswell:
Footballer Table:
Cricketer Table :
Scenario:
Now For Player Table:
If we select Player Type = Footballer then on “PlayerCode” field on the Player Table ,lookup should be open showing the records of footballer only and similarly with the case of cricketer.
For this to achieve we can use the relation called ‘Fixed field’ to do this.
Relation: Field Fixed
So, go to the Player table under relation node and create a field fixed relation:
Base enum 0 = Footballer
Now create a new record in Player Table:
It’s only showing lookup of Footballer code which having Player type = Footballer.
Base enum 1 = Cricketer
Then create another relation for Table Cricketer
It’s only showing lookup of Cricketer code which having Player type = Cricketer.
Kindly let me know above process for Field Fixed is correct ?
Later i will post Related Field Fixed***
Please give me more shed on this.
Thanks!
Arpan
