hi, a newbie question here. Table 1 - articl...

(Peter Westin) #1

hi, a newbie question here.

Table 1 - articles with article number, name and category Table 2 - i like to choose an article from table 1, and the app the should view the assigned name and category from Table 1.

How to do?

(Suvrutt Gurjar) #2

Hi @Peter_Westin,

Please define the ItemChecked table’s ArticleNummer column as (Ref) reference type. Please define the referenced table name as “Invetory List” while defining this ArticleNummer column of ItemChecked table.

Also ArticleNummer column should be a primary key column in the Inventory list column.

Now please define the attributes of Namen and Kategory columns of the ItemChecked table.

Please define the app formula as [ArticleNummer].[Namen] for Namen column of ItemChecked Table.

Please define the app formula as [ArticleNummer].[Kategory] for Kategory column of ItemChecked Table.

Hope this helps.

(Peter Westin) #3

@Suvrutt_Gurjar Txhs!