I have a tableview in which I want to show some products from a shoplist with some extra value.
I have a table shoplist_product, this is the datasource off the form.
shoplist_product is linked to user_product, since our clients have there own code for certain product, we store them here.
The relation also uses a global variable
and user_product is linked to product, in another database, so we can link the clients data to our internal product codes.
I think I did all this as I should. The data is present in the database. But my tableview does not give any data from either user_product or product. Only from it's foundset shoplist_product.
- Code: Select all
application.output(foundset.shoplist_product_id);
application.output(foundset.shoplist_product_to_user_product.user_product_id);
application.output(foundset.shoplist_product_to_user_product.user_product_to_product.name);
- Code: Select all
64BB8F1F-B6DD-470C-8A94-74F3D3966E73
<null>
TypeError: Cannot read property "name" from (C:\Users\Nick.RECYCA\servoy8_Recycom\rec_rbs\forms\frm_shoplist_product_list.js#123)
TypeError: Cannot read property "name" from (C:\Users\Nick.RECYCA\servoy8_Recycom\rec_rbs\forms\frm_shoplist_product_list.js#123)
at C:\Users\Nick.RECYCA\servoy8_Recycom\rec_rbs\forms\frm_shoplist_product_list.js:123 (onRecordSelection)
What am I doing wrong?