Different users write to different tables?

[hopkins]

I have a need to allow multiple users to have access to the same form, but restrict the information they retrieve from the database via reports.

For example, my "transaction" table records all the information regarding the different projects I track expenses for. There are 2 managers who, based on the Responsibility Centre number they input in the form, need to be able to retrieve or enter only information for the Responsibility Centre they are responsible for.

Can I do this from 1 form and 1 table? The built-in Access security will restruct access to the tables, but how do I sort the information on input or when running reports?

Should this be posted in another forum?I ca Zip a blank database for you to look at if need be.

Trish

 

[hopkins]

Sounds in-depth for a novice user such as myself, but definatey a challenge I am willing to take on.

I will work on this over time and possibly will be back with questions, although I do see some posts in this forum that address the issue.

Thank you!