>Thanks Barbara
>
>I was wondering what you ment with your reply.
>
>I did not include the User table in the view!
>
>After reading your answer I tried the following
>
>My production table and my user table in the view.
>I Join the production.dep with the user.dep
>
>I have 1 parameter the user ID
>
>In my DE beforetableopen I have
>PUBLIC userid
>
>userid=pUserID
>
>Where pUserID is the ID for the user when logged in to
>the software.
>
>This seems to do it.
>
>
>WHO I DONT UNDERSTAND YET??!!
>
>Best regards
>
>Per Simmersholm
Per, if you have more troubles, just cut the SQL from your view designer and paste it into a message. We'll be happy to look at it for you. Glad it seems to be working.
Barbara