Use more than one table with multiple records in one form

Nuno_Pereira

How i can use data from more than one table in a form, I try with a variable of type record but with that I only get one record at a time. Am I doing something wrong? what i have to do to have multiple records in various tables only in one form? Without use a subform...

Balello

Forms are always record based. You can workaround this by defining the form based on integer virtual table and showing record variables instead of rec on tableboxes.... But you must write code on a lot of triggers to deal with it... or the form must be uneditable. Is it necessary?



The answer should be: yes, because I want to try!

robson

It is possible by using Temporary table variable. Please see Navision FORM 542 Default Dimensions-Multiple. You can modify the function GetDefaultDim in OnOpenForm trigger to get records from multiple tables.