>I have a table with different departments
>I have a table with a user ID and witch department
>this user can acsess.
>
>Im using a view on the table.
>This view is displayed in a grid.
>
>The table with the User ID have several dep.
>ID dep.
>FI 1
>FI 2
>FI 3
>
>How can I filter out so the view only displays
>info from dep 1,2,3
>
>It seems to me that only the first FI 1 is displayed.
>
>Best regards
>Per Simmersholm
Your view doesn't need to include the FI field. If only the first record is displayed, then possibly your SQL is incorrect. COuld you post it on this thread? Thanks,
Barbara