>Dear Foxpro'ers,
>
>We decided to use views for all of our forms.
>
>In our security form I use page frames. The first page called " rights per users" I have text fields in which you can put a user. Also I have a grid. In the grid I have a combination of two tables.
>Items table and acces table.
>
>In the user table you will find the user information.
>In the items table you will find all the different modules which can be accessed
>In the access table you can see if a user has access to an Item
>
>I made a view combining the tree tables. I have related the tables like this: User --> Useracces --> Item
>
>But in the grid I will see all the items of all the users when I select one user.
>
>I have tought to make a view only with Useracces and item and then make a relation with a User view.
>
>The second page called " Item acces" I'm looking the other way around. I select an Item and I can see which user has access to it.
>
>So I also made a view combining the tree tables. I have relatet the tables like this: Item --> Useraccess --> User
>
>I suffered with the same problem with the information displayd on the grid.
>
>My questions are:
>
> How can I solve this problem the right way?
> Can you make so many views as you want from on table and use it in a form, or are the limitations?
>
>
>I'm looking forward to your reply
>
>
>Your Faithfully
>
>
>Luco Buhrs
>
>On Koos Veel's account
Hi Luco (name right?),
First you can create as many views as you want (and open within system limitations, not VFP , ie: file handles). They are not physical tables so is a convenient way to have data in many ways. But here it sounds what you need is a parameterized view. I would suggest reading Views in depth on online help.
Cetin