Granting access

[sojahseh]

Hello all,

I have a database that I use to run a small manufacturing business. I have a complete history of our production, and I'd like to give access to some of this information to a couple of my largest customers via the web.

How can I give them access to only the records that pertain to them? I have set up an account with privileges for one customer, but all the fields say no access, and all the records are available. I'd like to set it up so that when one of them logs in, they can only see records pertaining to them, using the customer ID# I imagine.

What am I missing?

Thanks,

MVC

[mr_vodka]

Here is a demo file.

http://fmforums.com/forum/showpost.php?post/303335/