How can I restrict access to a single record?

[jmacneil]

I have three companies that will share the same database but I need to
restrict access to some of the records to one of the companies. But not all
of the records need to be restricted. Any help is appreciated.

 

[White Bilky]

I have three companies that will share the same database but I need to
restrict access to some of the records to one of the companies. But
not all of the records need to be restricted. Any help is appreciated.

Create queries and set permissions accordingly.

www.keithwilby.com