Hi partner,
I would recommend you create an entity called "Order Product", and create two lookup fields for it, one is related to Product entity, the other is related to Order entity, so that it can be an intersecting entity between Order and Product.
Step 1. Create an new entity called "Order Product".
Step 2. Create two lookup fields for Order Product.
Step 3. Create some other fields, like Quantity, Unit, Price Per Unit, Extanded Amount, some of which can be calculated fields.
Add these fields on the form and view of Order Product.
Step 4. Insert a sub-grid of Order Product on the Order form.
This way, we can see the product and its price and amount in the sub-grid of Order form.
---------------------------------------
In fact, Dynamics 365 Sales has built-in Order and Order Product. If you have Dynamics 365 Sales in your environment, you can use them directly.
