Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Support forum
Design your application
[SOLVED] How to use Foreign Key?
  • 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
Forum
Support forum
Design your application
[SOLVED] How to use Foreign Key?
Time to create page: 0.105 seconds
“
”

Really great Joomla tool Cook is a great piece of kit for creating Joomla components. It uses a drag-n-drop interface to build tables and fully featured pages. You can test your component in a sandbox before downloading it packaged up ready to install. The developer is responsive on the support forum.
Twev (JED)
          

Get Started

Log In Sign In