F
fordrules01
Hi,
2 questions to ask.
1) I have a CRM database that tracks all correspondance to a specific
contact through "ContactID". These contacts are then linked through joining
tables to both the centres and councils they work at. I have 3 main forms set
up for "Contacts", "Councils", "Centres". Each of these currently has a
number of subforms which show the relationships between the 3 entities and
the specific one i'm interested in is the "Correspondance_Subform".
Correspondance is only linked to ContactID however i want to display all the
correspondance for a council even if its through more than one contact.
I'll talk in terms of 2 forms here just to make it easier and only deal with
the "Council" and "Contacts" form. I have the "Council correspondance
subform" linked to the "CouncilContacts_Subform". The "Council
correspondance subform" currently shows only the correspondance for which
ever record is active in the "CouncilContacts_Subform". Is there a simple way
to get it to display all correspondance for all contacts listed in the
"CouncilContacts_Subform"?
2) Dealing with the same 2 forms. I want the user to be able to add
correspondance with a council straight from the council subform. Where i run
into problems if the contact they are making it with is not currently in the
ComboBox that lists all our contacts. I have set up a command button that
opens the a new contact form but i want it to automatically link it to the
council through the "ContactsAtCouncil_Subform" so the user does not have to
type this in.
All help greatly appreciated.
Cheers
2 questions to ask.
1) I have a CRM database that tracks all correspondance to a specific
contact through "ContactID". These contacts are then linked through joining
tables to both the centres and councils they work at. I have 3 main forms set
up for "Contacts", "Councils", "Centres". Each of these currently has a
number of subforms which show the relationships between the 3 entities and
the specific one i'm interested in is the "Correspondance_Subform".
Correspondance is only linked to ContactID however i want to display all the
correspondance for a council even if its through more than one contact.
I'll talk in terms of 2 forms here just to make it easier and only deal with
the "Council" and "Contacts" form. I have the "Council correspondance
subform" linked to the "CouncilContacts_Subform". The "Council
correspondance subform" currently shows only the correspondance for which
ever record is active in the "CouncilContacts_Subform". Is there a simple way
to get it to display all correspondance for all contacts listed in the
"CouncilContacts_Subform"?
2) Dealing with the same 2 forms. I want the user to be able to add
correspondance with a council straight from the council subform. Where i run
into problems if the contact they are making it with is not currently in the
ComboBox that lists all our contacts. I have set up a command button that
opens the a new contact form but i want it to automatically link it to the
council through the "ContactsAtCouncil_Subform" so the user does not have to
type this in.
All help greatly appreciated.
Cheers