Welcome, Guest
Username: Password: Remember me

TOPIC: [SOLVED] How to use Foreign Key?

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

  • wrhein
  • wrhein's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Thank you received: 1
  • Karma: 0
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
Last Edit: 09 Jan 2012 13:58 by admin.
The administrator has disabled public write access.

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

  • molenwal1
  • molenwal1's Avatar
  • Offline
  • Senior Member
  • Posts: 63
  • Thank you received: 17
  • Karma: 3
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 administrator has disabled public write access.
The following user(s) said Thank You: admin, wrhein

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

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

your solution solved my problem.

greeting

Wolfgang
Last Edit: 06 Jan 2012 19:16 by wrhein.
The administrator has disabled public write access.
Time to create page: 0.100 seconds

Get Started