TOPIC:

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

MorganL
Topic Author
Offline
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 Topic Author Offline 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

Romkabouter Offline Elite Member Posts: 310 Thank you received: 131	I sometimes have to reload the page to see the new relation.
	Please Log in or Create an account to join the conversation.