We don't deal with companies but with Municipalities. What we did is .....

1) Create a table of users
2) Create a table of municipalities (or companies in your case)
3) Create a table of user2munis which specifies which users have access
to which munis.
4) At logon the application checks to see which municipalities the
person logging on has access to. If there is more than one, then the
user selects which municipality he wants to work on. Then every select
requires a WHERE MUNIID = :MUNIID to ensure that he can only see those
records.

This works well for us.

Todd



Damian Dowling wrote:

> Hi
>
> 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?
>
> Regards
>
>
> Damian Dowling
> IT Manager
> Pallas Foods Ltd
>
> Phone: + 353 69 20200
> Fax: + 353 69 20201
> Email: damian-dowling@...
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> <http://rd.yahoo.com/M=217097.1884387.3412360.1261774/D=egroupweb/S=1705115386:HM/A=999859/R=0/*http://service.bfast.com/bfast/click?bfmid=29150849&siteid=39282504&bfpage=account>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .

[Non-text portions of this message have been removed]