Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Support forum
Interface - Online generator
Problems with FK (multiple uses of same tables)
  • Page:
  • 1

TOPIC:

Problems with FK (multiple uses of same tables) 29 Jun 2018 13:50 #15594

  • MorganL
  • MorganL's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
I have a table called

PLATFORMS and a table called CONTRACTS
I want TWO FK tables cross relation tables for a one to many relationship that reference the same table

Plaftorms Pitched
Platforms Guaranteed

However as they have the same structure (CONTRACT FK/ PLATFORM FK) the builder will only allow you to drag in ONE (first one created), the other doesn't exist in the list of fields

This can be replicated 100% of the time
Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla

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

Last edit: by MorganL.

Problems with FK (multiple uses of same tables) 29 Jun 2018 14:14 #15595

  • MorganL
  • MorganL's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
After redoing the tables, but adding a table, then the fields.. closing down the builder, adding the next table.. i was able to add the fields.

Wierd

This post can problably be ignored
Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla

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

Problems with FK (multiple uses of same tables) 02 Jul 2018 18:32 #15597

I sometimes have to reload the page to see the new relation.

Please Log in or Create an account to join the conversation.
  • Page:
  • 1
Forum
Support forum
Interface - Online generator
Problems with FK (multiple uses of same tables)
Time to create page: 0.369 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

Log In Sign In