Allocating work to individuals (1 Viewer)

[marleyuk]

Hi,

I have a database that uses a table to capture work by reference number. I would like to be able to allow users to only be able to see work they have been allocated.

Can anyone point me in the right direction please?

Thanks,
Ian.

 

[missinglinq]

To start off, you'll need:

1. A way to identify the user who is opening the Form
2. A Field in the underlying Table that holds the name of the user that has been allocated the work
3. Filter the Form, when it loads, based on #1 & #2

Linq ;0)>

 

[jdraw]

As linq says users should interact via forms and not have direct access to tables.
Good luck with your project.

 

[marleyuk]

Thanks for the responses. Do either of you know of any examples of this working?

 

[jdraw]

What have you tried? Here's a youtube video that may get you started. There are several videos at the link
http://www.youtube.com/watch?v=ySyMn3H4rvg