[eluser]kre8ivdesigns[/eluser]
ok i have redesigned the whole database to try to follow database norm rules. Now I will start off by populating a date table which would have a relationship between the rate table and the reservation table.
reservations table
id
checkin
checkout
confirmation
dates table
id
date
reservations_dates table
id
reservation_id
date_id
rate table
id
rate
rate_date table
id
rate_id
date_id
I think here I can have a better chance of adding a rate then relating that to dates --> then to reservations.
Feedback appreciated...
