Hi SN Legion,
I'm reaching out here to seek some assistance. I'm currently working on a project and am relatively new to the platform. I'm developing an application for creating invoices. As part of this project, I'm building everything from scratch, without utilizing any existing workflows or databases, to gain a deeper understanding of the system.
To proceed, I need to create tables for orders and order details, and I'm following the model of the REQ (Request) and RITM (Requested Item) tables.
Can anyone help me understand how to retrieve data, such as the price shown in the image above, from the RITM (Requested Item) table? Should I achieve this through UI actions or workflows?
Additionally, I've created a table for products where product IDs, types, and prices are stored. In my "orders_details" table, the "IDProduct" field is referenced to the product table to retrieve product names and prices. How can I populate the "price" field in the "orders_details" table with data from the product table?
This is how is look so far....
