JobTraking Database
Posted: Thu Apr 28, 2011 2:58 am
Hi Steven
A little while ago you send me a database (as a sql file) where you explained how some of my challenges could be solved. I studied yours and it helped me to some extend. One issue with using the Look up field is that you have to have the record before you do a lookup. In my case the customer calls you enter his details. Then you add the job and then you enter the job events.
Well, have a look if you are interested with what I have come up. I still have to do more reports and I have to do something about referential integrity. At the moment one could delete a job without deleting the events which would leave dormant events in the system.
Thank you for your excellent work
Fundi
A little while ago you send me a database (as a sql file) where you explained how some of my challenges could be solved. I studied yours and it helped me to some extend. One issue with using the Look up field is that you have to have the record before you do a lookup. In my case the customer calls you enter his details. Then you add the job and then you enter the job events.
Well, have a look if you are interested with what I have come up. I still have to do more reports and I have to do something about referential integrity. At the moment one could delete a job without deleting the events which would leave dormant events in the system.
Thank you for your excellent work
Fundi