Welcome, Guest
Username: Password: Remember me

TOPIC: Filtering Foreign Keys

Filtering Foreign Keys 16 Nov 2014 17:25 #12777

  • rholzler
  • rholzler's Avatar
  • Offline
  • Junior Member
  • Posts: 30
  • Thank you received: 1
  • Karma: 0
I am trying to provide a front-end form for users to select an item from a list (foreign key list). The problem is that the select list, which is a Foreign Key field, displays items that belong to other users.

Example:
Table: Page
==>Foreign Key =>CreatedBy
==>Title
Table: Presentation
==>Foreign Key =>CreatedBy
==>Foreign Key =>Page[Title]

The problem is that the form on the Presentation page shows Page[Title]'s created by other users. How can I get the form to filter the selection list to show only pages created by the user?
The administrator has disabled public write access.
Time to create page: 0.060 seconds

Get Started