For a little backstory you can review this link... if ya want...



http://forum.strataframe.net/Topic4501-21-1.aspx



Here is my question... I'll do my best to explain it clearly ... ;-)



I have a table called Locations... Here is a sample of the records



LocationID LocationName RBSKey

1 Canton RBS.Canton

2 New Philly RBS.NewPhilly

3 Champioin RBS.Champion



We are controlling the locations our users have through RBS. That is why i included the above link... You guys gave me the idea earlier...



Now my question is this... I want to create a view that will only show the Products available in the locations the user has permission to. This would be easy if they could only have permission to one location... but they can have permission to multiple locations... so rather than front load all the records and then run a for...next loop and delete all the records they dont have access to ... i'm hoping I can create a view that will use the RBS tables linked by the RBS keys in the locations table in my database.



Is this clear?