I am completely stumped and was hoping you could help me. I know I've done this a couple of years ago, but for the life of me I can't remember how I did it now!
I have a master dbase that has a table with Name, Organization, Organization addy, phone, email as well as home addy, phone, email, AutoID and contact type. Contact type is CCP, NAC, Board, or CCP Nac. From this table I need to connect to other dbases which have information particular to just those contact types. The autoID that is assigned in the master dbase becomes the ID# for that person no matter how many other dbsaes they appear in. How do I relate/link these other dbases to the master dbase so that if they are just a CCP contact, their Master dbase info appears in the CCP dbase where other pertinent info just for CCP's is kept? Or make it appear in the NAC dbase only?
I've tried relating them, but there isn't anything the same in the databases. I thought of subforms; but the CCP and NAC dbases are separate from the Master dbase so couldn't find a way to do that.
You don't know how much I'd appreciate your help here!!
I have a master dbase that has a table with Name, Organization, Organization addy, phone, email as well as home addy, phone, email, AutoID and contact type. Contact type is CCP, NAC, Board, or CCP Nac. From this table I need to connect to other dbases which have information particular to just those contact types. The autoID that is assigned in the master dbase becomes the ID# for that person no matter how many other dbsaes they appear in. How do I relate/link these other dbases to the master dbase so that if they are just a CCP contact, their Master dbase info appears in the CCP dbase where other pertinent info just for CCP's is kept? Or make it appear in the NAC dbase only?
I've tried relating them, but there isn't anything the same in the databases. I thought of subforms; but the CCP and NAC dbases are separate from the Master dbase so couldn't find a way to do that.
You don't know how much I'd appreciate your help here!!