|
Title: Multiple CRUD apps to share data betwen tables in a db for basic calculations Post by: swells808 on September 14, 2014, 05:16:23 PM I am stuck and need a suggestion. I am building a web app with 2 different crud tables to essentially track vehicle use. So on one page a driver will log his time used in a specific vehicle and on the other its a maintenance log of each vehicle. I have 2 tables in a database (one for each CRUD table so driver and maintenance).
What I need to figure out is how to do a math formula based on usage of a vehicle from the driver's page that reports to the corresponding vehicle in the maintenance table. On the maintenance page I need the mechanics to be able to log when a vehicle has been inspected. The idea here is this will reset the amount of time until the mechanics need to take a vehicle out of use for scheduled maintenance. Any suggestions? |