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

TOPIC:

Limit results in a n:n pivot table based on value 10 Aug 2016 11:48 #14413

  • MorganL
  • MorganL's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
I have a table called

table1

and another two tables called

regions,
territories


territories all have a FK of region (i.e territories belong to a region)

Table1 has two cross reference tables

table1 - regions (n:n)
table1 - territories (n:)


and using the pivot method built into J-Cook builder by default

I want to make it so that a person chooses REGIONS first when completing table1 (multiselect, entries go into table1region XRef table), but then in the next field, rather than being able to multselect ALL TERRITORIES, they are only presented with those that belong to any selected regions.

I can obviously fire an auto save when a user adds regions, but quite sure what model to alter to build in the complex join for the territories XRef

Any advise greatly appreciated
Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla

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

Last edit: by MorganL.
  • Page:
  • 1
Time to create page: 0.093 seconds

  I found "cook" two days ago. Played around with it for a day and then within a day got rid of two legacy applications in IBM Lotus Domino Notes and replaced them with "cook". It was really easy. A piece of cake. Actually it was even easier than cooking. Cooking involves more work than developing with "cook". What can I say about "cook"? Great application great price for what it delivers great forum with a lot of information and fast responses active and friendly community fast forward moving development cycle So what should I say "Monsieur Le Cook"? Keep the good work going it will lead to success. Having become a paying member in the words of Edith Piaf may I say ..... non rien de rien ... je ne regrette rien. Vive La France.
FK (JED)
         

Get Started