Proprietary Data on Intranet

[ontsjc]

Hello Folks,<br><br>I hope this isn't too long winded. I'm developing an application for a corporate intranet that handles proprietary chemical data for different clients.&nbsp;&nbsp;I need help with some design aspects.<br><br>I need to design a form that allows different client managers to enter client specific data into a community data table, view/edit the data that they've entered, but not be able to view any other client's data in the same table.&nbsp;&nbsp;I envision using just one table since there are lots of clients (100+) and individual tables for each one seems cumbersome.<br><br>I have a password protected login procedure to identify the person on-line and my idea for the data entry screen is to use a grid control attached to the community table for data entry.&nbsp;&nbsp;My problem is how do I restrict the view of the data to just the data appropriate to the client manager in a multi user environment.&nbsp;&nbsp;Or is there a better concept I should be using.&nbsp;&nbsp;Any information would be greatly appreciated as this is my first multi user and on-line application.

 

[foxdev]

There are several ways, assuming you'll have a CLIENTMGRID column in the table:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;1) set filter (easy but poor performer)<br>&nbsp;&nbsp;&nbsp;&nbsp;2) create an updatable view with a bind parameter for the CLIENTMGRID column.<br><br>The way #2 works is you'll create a view in the View Designer; in the WHERE clause, you'll have something that evaluates to:&nbsp;&nbsp;CLIENTMGRID = ?gcCLIENTMGRID<br>then in the login screen, set gcCLIENTMGRID to the logged-in user's ID.<br><br>I'm sure others can come up with some other approaches that may be even better suited to you. <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>