to make it short: FM13, Advanced.
- 4 tables created: customer, invoice, item and invoiceitems.
- Relations: Customers -> invoice -> invoiceitems -> Article
- References set to the appropriate fields:
the "article_id" from invoiceItem table with the field "article_id" from table "Article"
the "Description" from invoiceitem table with the field "Description" from the table "Article"
the "purchase price" from invoiceitem table with the field "purchase price" of table "Article"
- Portal in layout invoice
- Typing Article_ID in Article-ID of invoiceItem but the filed is empty.
I tried everything. Am relatively new to FM. what is wrong with the reference options?