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.110 seconds
Great UX great performance and definitely a time saver. It only took me 10 minutes of playing around before purchasing a subscription and right now I just want to throw more money at you! I just started a new project and after just 4h I can already tell it probably saved me several days of work. I'm building a wholesale ordering system with sales rep management. I have not looked at the code yet but so far: impressive.
flip (Forum)

Get Started