ClearlyAnIdiot
Registered User.
- Local time
- Tomorrow, 04:27
- Joined
- Aug 22, 2013
- Messages
- 39
I'll illustrate my problem with pictures.
Basically, within a company, a director can have an alternate. I have done this by linking the relationship between a person and a company (company-personID) with the table "alternates". In a subform for the information about the company itself, it shows the people associated with the company, as well as their alternates (assuming they're a director).
It works just fine when I view a director's alternate, as John Tong here has his alternate as the person with relationship number 7. However, the whole thing is made useless when I view it from an alternate director's point of view, like Peter Chan, where he's displayed as the director, and the alternate is null. After poking around for a bit, it turns out that the child field is ALWAYS director.
What I want is for it to show the alternate or director based on who's being shown in the subform, i.e. Peter Chan is filled as alternate with the director being shown as "1". I've tried setting up expressions and putting up multiple master and child fields, but they just mess up Access. Any solutions?
Oh, and if someone knows how I could display the names instead of the company-personID in the "alternates" subform, that would be great. Naturally, the source would still have to be the relationship, but it'd still be nice if it would show up with the name instead.
Basically, within a company, a director can have an alternate. I have done this by linking the relationship between a person and a company (company-personID) with the table "alternates". In a subform for the information about the company itself, it shows the people associated with the company, as well as their alternates (assuming they're a director).
It works just fine when I view a director's alternate, as John Tong here has his alternate as the person with relationship number 7. However, the whole thing is made useless when I view it from an alternate director's point of view, like Peter Chan, where he's displayed as the director, and the alternate is null. After poking around for a bit, it turns out that the child field is ALWAYS director.
What I want is for it to show the alternate or director based on who's being shown in the subform, i.e. Peter Chan is filled as alternate with the director being shown as "1". I've tried setting up expressions and putting up multiple master and child fields, but they just mess up Access. Any solutions?
Oh, and if someone knows how I could display the names instead of the company-personID in the "alternates" subform, that would be great. Naturally, the source would still have to be the relationship, but it'd still be nice if it would show up with the name instead.
Last edited:
