Hello, I added an additional column in the aspnet_Users table in my database. This stores the user's company ID key. Also in every company record in the database, there is the same company ID key, which corresponds to its respective company in another table. How, do I filter all database queries after that user is logged on, based on their Company ID key, so that any and all database queries on any page the user visits only return database records that also have that same company ID key? Ps., I am using Visual Studio 2005, SQL 2005
This has been a tough one for me, probably with a simple answer. No guesses please, I have gone through them all. Any help and a solid answer would be much appreciated!
Thanks a million!