Newbie needing assitance I am trying to work out the best way to calculate the next service date.
I have two main tables the Property table which has the service schedule eg every 3 weeks (set at value 21 for 21 days)
and a Service Dates table which shows when i was last there and if it was completed.
I need to figure out a way to work out when i am next due to go the property.
Current Idea is to add an new field in the service dates table that is a serial number and add one per service date entered, then create a script that searchs for that property and obtains the highest serial number and then addes the schedule time frame to it.
But not sure how to go about creating the script.
Suggestions or Ideas would be great. Sample?
Appreciations for the Help!!