[AccessD] Split table's records according to user acoount

Dont assign users to records assign security levels to both user and
records.
On Mar 17, 2012 1:02 PM, "Non-Linearly" <nonlinearly at gmail.com> wrote:

> I want the records in a table to distribute according to its users. I could
> create a field that holds for each entry, the user that has the rights to
> see it. But the problem is that a record may need to be viewed from more
> than one user!
>
> So I made a second table that more than one records each with the user
> account and the id from the first record. So with this way I can assign
> more
> than one user to one record.
>
> But then more problems emerge:
> 1. To take the records assigned to a specific user I have to run a query
> that join the above tables. The form that is bound to this query cannot be
> updateable!
>
> 2. The query can be achieved only with IN operator and is very very very
> slow.
>
>
>
> Thanks
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>