Welcome, Guest
Username: Password: Remember me

TOPIC: Problems with FK (multiple uses of same tables)

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

  • MorganL
  • MorganL's Avatar
  • Offline
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
  • Karma: 16
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
Last Edit: 29 Jun 2018 13:50 by MorganL.
The administrator has disabled public write access.

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

  • MorganL
  • MorganL's Avatar
  • Offline
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
  • Karma: 16
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
The administrator has disabled public write access.

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

  • Romkabouter
  • Romkabouter's Avatar
  • Offline
  • Elite Member
  • Posts: 310
  • Thank you received: 131
  • Karma: 48
I sometimes have to reload the page to see the new relation.
The administrator has disabled public write access.
Time to create page: 0.093 seconds

Get Started