chellebell1689
Registered User.
- Local time
- Today, 04:27
- Joined
- Mar 23, 2015
- Messages
- 267
Ok so I want to generate a subreport for my deacons that show what families have been assigned to them. I kind of know how to set this up, but I'm missing one piece.
Using the wizard I created a subreport that pulls the name & phone number(s) for each member with the same family ID, and Deacon ID (which pulls the name, number and FID from the member table, then checks the family table and gets the deacon ID). My question is, how do I tell the report to check if the current member I'm looking at is a deacon and if so use their deacon number as the reference number for "Deacon ID"?
Let me know if you need more info. Hope I made that clear enough. Thanks in advance.
EDIT: Oh I forgot to say, I have a table for my deacons that links the member through their EnvNum (if they're a Deacon). Not sure if I'll need that table for this, but thought I'd mention I do have one.
Using the wizard I created a subreport that pulls the name & phone number(s) for each member with the same family ID, and Deacon ID (which pulls the name, number and FID from the member table, then checks the family table and gets the deacon ID). My question is, how do I tell the report to check if the current member I'm looking at is a deacon and if so use their deacon number as the reference number for "Deacon ID"?
Let me know if you need more info. Hope I made that clear enough. Thanks in advance.
EDIT: Oh I forgot to say, I have a table for my deacons that links the member through their EnvNum (if they're a Deacon). Not sure if I'll need that table for this, but thought I'd mention I do have one.
Last edited:
