Re: sharing records with assigned users

Ave, That makes sense... Actually I think I know exactly what you're saying and I think it's gonna work that way. Let me do this. Thanks a ton! On 8/26/04 2:42 PM, "Jason Wong" <php-general@gremlins.biz> wrote: > On Friday 27 August 2004 01:49, PHP Junkie wrote: > >> Coming back again to my problem.. >> If, in the table I'm storing my records, I create a field which stores the >> Users allowed access to that particular record, then in case of multiple >> users, that single field will hold multiple user names... Which is a >> problem for me. And I might be applying a very wrong approach, logically, >> which is why I came forward for some assistance. > > You have a new table which has 2 columns: > > record_id, user_id > > Then: > > SELECT user_id FROM new_table WHERE record_id = whatever;