G
Guest
I have several tables that are related to each other (one to many in most
cases) I have a customer table, event table, and equipment table. The goal
is for a customer to go online, enter their personal data (this will update
the customer table), then enter/select the date time of their event, which
pieces of equipment they want (pulling data from the equipment table) and
where the event is going to happen; this will update the event table. I need
to figure out the amount of time they will be renting the equipment for (from
the starttime field and endtime field) then determine the cost per hour (from
the equipment field), multiply the right pricing tier and hours, plus add in
mileage to determine a total cost. I really would appreciate any help I
could get, I plan on looking at similar data bases that are already online
and see if they help.
cases) I have a customer table, event table, and equipment table. The goal
is for a customer to go online, enter their personal data (this will update
the customer table), then enter/select the date time of their event, which
pieces of equipment they want (pulling data from the equipment table) and
where the event is going to happen; this will update the event table. I need
to figure out the amount of time they will be renting the equipment for (from
the starttime field and endtime field) then determine the cost per hour (from
the equipment field), multiply the right pricing tier and hours, plus add in
mileage to determine a total cost. I really would appreciate any help I
could get, I plan on looking at similar data bases that are already online
and see if they help.