Welcome, Guest
Username: Password: Remember me
  • 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
Time to create page: 0.058 seconds

I must say that I'm leaps and bounds ahead of where I would have other been with J2.5 with full thanks to the folks on this forum and specifically to Cook so you'll never hear me complaining.
gdpodesta (Forum)  

Get Started