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

TOPIC:

[SOLVED] How to use Foreign Key? 06 Jan 2012 12:15 #896

  • wrhein
  • wrhein's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 4
  • Thank you received: 1
Hello,

i have problem to use 'Foreign Key' on my Table. I can add 'Foreign Key' and fill up Fields label and name, but i to miss function to referent the other Table/Field.



may Tables:

Products:
Name | Num | Joomla user | category (Foreign Key)

Categories:
Name | Publish | Ordering


greeting

Wolfgang

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

Last edit: by admin.

Re: How to use Foreign Key? 06 Jan 2012 12:20 #897

Very simple, on the left of your screen you see the tables. Drag and drop the Category Table to the field in the Foreign Table Column. After that you can specify which field of the Category table should be displayed.
Molenwal1 Webdesign
www.molenwal1.nl
The following user(s) said Thank You: admin, wrhein

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

Re: How to use Foreign Key? 06 Jan 2012 19:11 #902

  • wrhein
  • wrhein's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 4
  • Thank you received: 1
Thank's molenwal1,

your solution solved my problem.

greeting

Wolfgang

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

Last edit: by wrhein.
  • Page:
  • 1
Time to create page: 0.078 seconds

I jumped and started to work on a demo component... but 2 days later this demo component became the real component. I just showed today the end result to my customer and he turned to me and said... "this is more than I expected"... All of this is because Cook did cut about 70% of my work and provided me more ways to improve the usability of the component. The end result was 17 tables all related between than to generate a full dashboard for the travel agents. Thanks for Cook developers for such great tool. This component would not be possible to be done at short time with all the features in it
Griiettner (Forum)  

Get Started