Have another table DocPermissions with two columns, a Client ID and a Document ID. Put
a row in that table for any Document/Client combination that is allowed.
At 03:34 PM 1/4/01 -0500, Peter Benoit wrote:
>Got a bit of a situation that I'm not so sure how to handle. It's something
>like this;
>
>I've 3 tables.
>
>Customers
>Clients
>Documents
>
>Each customer has multiple clients, and those clients are allowed to view
>certain documents. We can go along and add new documents and giving them
>settings to allow the customers clients to view them. The problem comes
>along when we get a new customer, and how to handle all the documents that
>new customer may or may not have privileges to.
>
>If someone has ideas for me on how to handle this, or has done something
>like this in the past, I'd love to hear them. I've really no idea what the
>best method for doing something like this may be, so I'm asking for your
>help.
>
>Thanks,
>Peter
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
