Subject Multiple Company Data in 1 Database
Author Damian Dowling

I want to store records for several companies in one database and only
allow the user to view the records from a selected company through views.
What i was hoping to do is have the client create a record with a SessionID
and CompanyID at Login, the Views would then use the SessionID to select
the correct companies records from the tables.

What would be the best way to achieve this?


Damian Dowling
IT Manager
Pallas Foods Ltd

Phone: + 353 69 20200
Fax: + 353 69 20201
Email: damian-dowling@...