my problem How to make relation between costs and details per every day
Problem
How to get cost per every day based on day detail table ?
Details
I designed database for booking hotels and program for tourists
but i face problem how to calculate cost of every program and hotels
Package 1 4 days
day flight hotel
day1 amsterdam to aswan Hilton
day2 Hilton
day3 Hilton
day4 aswan to amsterdam
Package 1 4 days costs(Here actually my problem )
day flightcosts hotelcosts
26/07/2017 500 50
27/07/2017 50
28/07/2017 50
29/07/2017 500