Posted by gregory.sharrow on 10/04/93 11:31

Erland,

Thank you for the response it was helpful. After reviewing my post I
see I should have presented at least one more example (or maybe I am
not completely understanding your reply).

In your version of the security_cross_ref table, how do you enter
multiple products, salesreps, or customers for a single user?

So let say I have a user 5 who has access to
products in (10,11)
or
customers in (20,21,22)
or
salesreps in (1)

How would I populate the cross ref table?


Because in reality my situation is

A user could have access to

0 to many products

and/or

0 to many customers

and/or

0 to many salesreps

[Back to original message]