Welcome, Guest

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

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

MorganL
Offline
Platinum Member
Posts: 438
Thank you received: 53
Karma: 15

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 Offline Platinum Member Posts: 438 Thank you received: 53 Karma: 15	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 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.

Forum

Support forum

Interface - Online generator

Problems with FK (multiple uses of same tables)

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

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

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

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

Get Started

Newsletter