woodeye

Relationship graph with Join table and Layout question

Discussion created by woodeye on Mar 20, 2014
Latest reply on Mar 23, 2014 by woodeye

I have 4 tables,related as follows:

 

MainTable -< JoinTable >- Territories -< Retailers

pkSALESREP_ID field is a global field. This field is set when the user logs in.

pk = primary key

fk = foreign key

 

MainTableJoinTableTerritoriesRetailers
pk_SALESREP_IDfk_SalesRep_ID


fk_Territory_IDpk_Territory_IDfk_Territory_ID



pk_Retailer_ID

pk_Join_ID

 

I would like to have a layout that shows in a portal, all the Retailers that belong with the salesperson who logged in. I would also, on the same layout, like to be able to choose a Territory and then only see those Retailers who are linked to both the SALESREP_ID and whichever territory chosen. If I start with the Territories TO, I am able to show Retailers in the portal, but only those associated with the current Territory.

 

Any suggestions would be greatly apprciated.

 

Thanks,

 

John

Attachments

Outcomes