Anveo Web Portal / Customize the User Interface / Creating Anveo Page using Virtual Tables

Creating Anveo Page using Virtual Tables

The setup of Anveo Pages based on Virtual Tables varys slightly from the setup of Anveo Pages based on tables in Dynamics. When creating a new Anveo Page Element you have to enter the identifier of the virtual table in the field Virtual Table Code instead of the table number. The table name shows the name of table ACF Virtual Data, in which all the data of your virtual table is saved in Dynamics. The definition of fields is similar to the field definition of fields in Anveo Pages (find further information here). Instead of field numbers you enter the identifier of the Virtual Table and the identifier of the field. You can – on the contrary to the field definition based on normal tables – specify different Virtual Tables on an Anveo Page Element and thereby compose the fields on the Anveo Page.

Table relations which contain virtual tables can not be set up as described here. You have to program these table relations instead as shown here, exeption: Table relations for search masks using the function VIRTUALFILTER() are described here.