Information générale
Titre:
Views with pageframes
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement