restrict employee to only certain companies data?

[advpay]

Hello,<br><br>When processing receivables for multiple Clients lets say 3 Clients.<br><br>Client1&nbsp;&nbsp;&nbsp;&nbsp;1,2,3...# of customers<br>Client2&nbsp;&nbsp;&nbsp;&nbsp;1,2,3...# of customers<br>Client3&nbsp;&nbsp;&nbsp;&nbsp;1,2,3...# of customers (all unique to Client)<br><br>I have the routine tables...<br><br>tblCusomer <br>tblInvoice&nbsp;&nbsp;&nbsp;<br>tblEmployee&nbsp;&nbsp;<br>MyCompany&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Each individaul Client by SetupID as Key<br><br>1. how can i keep transaction seperate unique in my table to allow only certain employees to Access certain Companies? <br>

 

[DougP]

Create a separte table that has 2 fields. EmployeeID and Customer ID<br>Then make the form where they edit or add information just look for Customers that are in the table that mathc their ID number.<br><br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[advpay]

ok thanks Doug,<br><br>One more for you?<br><br>How can I uniquly identify, for reports, only customers from certain Clients as all the data resides in the same tables...<br><br>Would I create a table with ClientID and link it to the Customer table and would it follow through payments, invoice...etc tables?<br><br>

 

[advpay]

also after thinking about your solution...<br><br>I have a client table set up...and I will add the EmployeeID<br><br>then I need to add the ClientID to the Customer table and make the relationship?