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
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.