Susan Harkins
ssharkins at bellsouth.net
Thu Apr 28 19:42:24 CDT 2005
But they don't apply to a single contact, do they? Perhaps it's the contact field that I don't understand. How would these values apply to a Contact entity? Susan H. On 28 Apr 2005 at 19:36, Susan Harkins wrote: > How could a contact be both IssuedTo and IssuedBy? I admit, I'm > confused by the purposes of the types. I feel like something's missing. > Quite common in repair shops etc. for Jobs. You have one master staff list which you use for everything including HRM and Job tracking A job comes in. It is: a. ReceivedBy - a person on the counter (who puts in in a stack) b. IssuedBy - a supervisor (who takes it from the stack) c. IssuedTo - a serviceman (who carries out the work) d. CheckedBy - a supervisor d. ReturnedBy - a person on the counter. Each of these is a field in the job record which stores the StaffID. -- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com