Hey guys i need some quick assistance. I got a presentation to do on wednesday.
i am doing a database for a catering company. the database has to be able to take orders, add customers and items to it. I used the entities Customer, Order, Order Line and Product. Order to Product is many a many so i created a link entity which is OrderLine. I am currently creating a form to take orders and i need the Unit Price to be calculated when an employee puts in the product item and then the quantity. Can anyone please assist me in doing this, i tried the expression builder but i am not getting through.
Also how can i make it possible that an order can take more than one product because obviously a customer would order more than one item.
ANY ASSISTANCE WOULD BE THANKFUL AND I AM PATIENTLY WAITING FOR A RESPONSE.