Thanks for your time Tom > Can the customer have more than one representative > at any one time or would they have one rep for a > period then another after then?
After payments, Representatives can change, so new payments may go to the same or other persons. > When a rep makes a payment is it on behalf of a > customer or on behalf of the rep? Payments are made by company *to* customer and/or representatives > If it is on behalf of the rep, why? > Does it later get assigned to a customer? > > What determines the relationship between the customer > and the rep? > > I have a persons table which can store an introducing > rep, a currently servicing rep and a last servicing rep. > > The payment header table has PersonID and the rep ID so > can store any number of combinations. > > There is a Personnel table that stores rep IDs. > > If I wanted to go further I could have a table between > Persons and Personnel that allowed for an unlimited > combination and history. That may be what you need. > > CREATE TABLE `PersonsReps` + > (`PersonID` INTEGER , + > `RepID` INTEGER , + > `Relationship` INTEGER , + > `RelStartDate` DATE , + > `RelEndDate` DATE ) Dear Tom, I think you go deep when you only need to stay on surface. My English don't help me to go very deep anyway. What I ask is a design solution. The information I give is only a prototype and is replicable to many situations. Another example I made my own: Table FATHER (FATHER_ID,...) Table CHILD (CHILD_ID,FOTHER_ID,..) Let's say we have a rule that we send an amount for each child over 18, otherwise to their father, so: Solution 1: Table SENDAMNT (SENDAMNT_ID,WHO_IS (father or child),WHO_ID (ID of father or child respectively) -or- Solution 2: Table FAMNTS (FAMNTS_ID,FATHER_ID,AMOUNT,DATE_SENT) and Table CAMNTS (CAMNTS_ID,CHILD_ID,AMOUNT,DATE_SENT) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
