Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

Filtering Foreign Keys 16 Nov 2014 17:25 #12777

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?

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.066 seconds

Real time saver and great Component Builder tool ! I have been developing with J-Cook Pro Component Builder for several months now and can say with all honesty that this product/service is second to none. The product is feature rich and is being improved and added to all the time. Do yourself a favor if you need to build a Joomla! Component then you can do no wrong in trying the product. You will save on time and effort while being able to deliver your project on time. J-Cook pro does the hard work for you you then have the freedom to fully customise the end result for your own needs. 

One word: Awesome.
Edwardcox (JED)
         

Get Started