I have 3 tables in my database.
Potential Partners
Pk CompanyID
CompanyName
Contacts Name
...
BusinessOpportunities
Pk OpportunityID
OpportunityName
Description
BusinessLead
...
OpportunityTeam
Pk OpportunityTeam_ID
CompanyID
OpportunityID
...
As you can tell, Potential Partners and BusinessOpportunities have a many to many relationship.
I am confused on how to diaplay this many to many relationship on my form. Right now I have 2 foms based on Potential Partner and BusinessOpportunity. Recently the user told me that a Potential Partner can have many BusinessOpportunities associated with it n vice versa. Thats when I created the intersection table OpportunityTeam.
Now, I want to make a subform on PotentialPartner form which will display the Business Opportunities(these r the firlds that I want on the subform-OpportunityNae, Description and Business Lead). I want to do the same thing with BusinessOpportunity form. I cant figure out how to do that.
I made a query based on Business opportunity table and made sure to include the primary key of Potential Partner. I created a subform on Potential Partner form using this query. It doesn't work. Don't know what I am doing wrong.
The error that I get is
Cannot add Record(s); join key of table 'table OpportunityTeam' (this is the intersection table) not in recordset.
Another thing that's bothering me is: Later when the users use this database would they be able to add Business Opportunities and Potential partners in the subform. Becaude its the Primary key which links these subforms to the main form and they will not know it.
Somebody Please help..it's urgent. I can also send my database if required
Thanx
Ekta
Potential Partners
Pk CompanyID
CompanyName
Contacts Name
...
BusinessOpportunities
Pk OpportunityID
OpportunityName
Description
BusinessLead
...
OpportunityTeam
Pk OpportunityTeam_ID
CompanyID
OpportunityID
...
As you can tell, Potential Partners and BusinessOpportunities have a many to many relationship.
I am confused on how to diaplay this many to many relationship on my form. Right now I have 2 foms based on Potential Partner and BusinessOpportunity. Recently the user told me that a Potential Partner can have many BusinessOpportunities associated with it n vice versa. Thats when I created the intersection table OpportunityTeam.
Now, I want to make a subform on PotentialPartner form which will display the Business Opportunities(these r the firlds that I want on the subform-OpportunityNae, Description and Business Lead). I want to do the same thing with BusinessOpportunity form. I cant figure out how to do that.
I made a query based on Business opportunity table and made sure to include the primary key of Potential Partner. I created a subform on Potential Partner form using this query. It doesn't work. Don't know what I am doing wrong.
The error that I get is
Cannot add Record(s); join key of table 'table OpportunityTeam' (this is the intersection table) not in recordset.
Another thing that's bothering me is: Later when the users use this database would they be able to add Business Opportunities and Potential partners in the subform. Becaude its the Primary key which links these subforms to the main form and they will not know it.
Somebody Please help..it's urgent. I can also send my database if required
Thanx
Ekta
