[AccessD] Table of Names

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




More information about the AccessD mailing list