Need calc total of order list of a single order searched by order number

[zabi]

Hello everyone

I have 2 tables very easy

Order


Order list

1 order has many Order lists

I have no idea how to get the total price for 1 order which will have many different order lists, please.

Thanks a lot in advance

[orange]

Here is a youtube video related to design and development of an operational Stock Control database

[zabi]

Here is a youtube video related to design and development of an operational Stock Control database

Thanks a lot for the link I have already been through that. the problem is I do not have Quantities. I have IMEI numbers for each order list which is a single mobile phone. so I cant have Quantity if I am going to use IMEI and it is a must to use IMEI.
This means I do not have taxes, shipping costs and anything but Prices. I also need them to show as listed in table view in a form just for a single record.
Thanks