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.079 seconds

Let me first state that this is an amazing and fascinating product exactly what I was looking for. In just a few hours (listening to the very well made and clearly understandable videos learning doing) I completed and installed my first component. I am now in the second refining phase. I will make a recommenation in JED. Thanks for the effort in creating such a great product. Incidentally some of the best Joomla extension I use are of French origin !
Giori (Forum)

Get Started