I have a Product table and order table. in product table i have productname, quantity, price. in order table i have productname(from product table), quantity ordered (manual entry) , and price (which should be price of the product times the quantity ordered). Is there anyway to achieve this in Mendix, Im new to Mendix. Please help.
Check the Pizza Mario tutorial project. It has exactly the things you describe.