Icehousman2
Registered User.
- Local time
- Today, 10:34
- Joined
- May 12, 2004
- Messages
- 45
I have three tables. tblAgent, tblRep, and tblOffice. I have included a picture to show the current relationships.
Normally, an office will be associated with only one Rep. When we start dealing with a new office, a single rep is associated with that office. However, occasionally reps will be given exceptions to an office. Meaning that a single Agent within an office will be associated with a different Rep then the Office as a whole. There are a number of reports that I need to create from these tables.
One is a list of each rep and all offices associated with this rep. However, this list should not include offices where you are only associated with an office because you have an exception there.
Two is a list of all agent exceptions for an individual rep and the offices associated with each exception.
Three is a list of all current exceptions that are associated with offices for a particular Rep. For example, if I am a rep I want to know all of the other reps who have exceptions at “my” offices. And the specifics of each exception.
Does this seem easily done with the relationships that I have set up currently? I would obviously like to keep this as neat as possible. Thank you for everyone’s help in advance.
Normally, an office will be associated with only one Rep. When we start dealing with a new office, a single rep is associated with that office. However, occasionally reps will be given exceptions to an office. Meaning that a single Agent within an office will be associated with a different Rep then the Office as a whole. There are a number of reports that I need to create from these tables.
One is a list of each rep and all offices associated with this rep. However, this list should not include offices where you are only associated with an office because you have an exception there.
Two is a list of all agent exceptions for an individual rep and the offices associated with each exception.
Three is a list of all current exceptions that are associated with offices for a particular Rep. For example, if I am a rep I want to know all of the other reps who have exceptions at “my” offices. And the specifics of each exception.
Does this seem easily done with the relationships that I have set up currently? I would obviously like to keep this as neat as possible. Thank you for everyone’s help in advance.