Database records?

[Clive]

Hi
I’m currently working on a database in sql 6.5,
My problem is that I’m trying to allow different companies to be able to update and select their own records, without been able to tamper with other records on the same tables,

Any body got any ideas on this?

Thanks

Clive

[Clive]

Thanks Chris...


------------
Chris at 8/17/00 6:13:39 PM

Create a seperate table with Company Names. Create a Foreign Key to the tables which need segregation referenceing the Unique ID (PK) of the given company. When you perform your selects or updates, ensure that you pass the companyID or Name in your Where clause!


------------
Clive at 8/14/00 1:26:57 PM

Hi
I’m currently working on a database in sql 6.5,
My problem is that I’m trying to allow different companies to be able to update and select their own records, without been able to tamper with other records on the same tables,

Any body got any ideas on this?

Thanks

Clive