AnsweredAssumed Answered

viewing records from related file (no portal)

Question asked by Wicktor on Jun 28, 2016
Latest reply on Jun 28, 2016 by Wicktor

Hello everyone,

I am totally stuck on this.


My situation:

TableA (300 records)

- KeyField (text)

- ....other fields

TableB (multiple records)

- KeyField (text)

- CalcField1 (text calculated value to show)

- CalcField2 (text calculated value to show)

- .....other fields

TableA is linked to TableB via KeyField (allowing creation of records on TableB)


I need to show in a single layout of TableA the values of each record of TableA::KeyField and related values TableB::CalcField1 and TableB::CalcField2 without using portals.


I can show each records of TableA using GetNthRecord ( TableA::KeyField ; n )

But how do I get related values from TableB for each record of TableA in the same layout without portals ?


Thank you for your help,