Assign User to certain part of database

[MichelleVL]

Hi I have database:



So I have tblBusiness with one-to-may relation to department. Once business can have many department. But now... I have lot users. I want assign some user to Business A and some other users to BusinessB.

When John login he must only see Business A
When Mary login she must only see Business B

Business A
- Department A
- Sales Jan
- Sales Feb
- Department B
- Sales June

Business B
- Department 1
- Sales May
- Sales Aug
- Department 2
- Sales April
- Sales Feb

Can some one please say how to do?

[ranman256]

I have a tUser table...userID, dept
BSmith,A
SueH,B

When the form opens,it gets their userID,I lookup the dept. I fill invisible text boxes on the form.

TxtUser =Environ("username")
txtDept=Dlookup("[dept]","tUser","[userID]='" & txtUser & "'")

then all queries look at the dept text box.
select * from table where [dept]=forms!frmMain!txtDept

[MichelleVL]

hi, is this for to see reports? I mean different users to enter data only for his/her assigned Business....