I have a table for something like "Events" or Classifieds.
it is a "user" add edit Page or table. under Advanced security settings, I have set this table to "Users can see others data, can edit their own data only.
now what I want is to ad a view to that same table, but have it only display the session Users entries. ( making it user friendly to keep their records up to date)
have tried making a custom view from first table, calling it something like "My Events" and setting it to "Users can see and edit their own data only.
but it creates a Double "My Events" in the menu's (which you can see in PHPRunner ) and and error page when you try to look at the original "Events List" page, once you check it online. I already have one custom view of the same table. and it and the original are working as desired. is two custom views of the same table too many?
have tried using the where clause in Edit SQL query, but it doesn't seem to like the use of a "@$_SESSION["UserID"]"
what is the best way to get this feature to work.