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.097 seconds
“
”

Just wanted to congratulate you on the J-Cook website / web development tool. In a couple of visits I've had a play around with Cook and have to say I think it is fantastic.  I've played with a number of component builders in the past and yours is certainly looking like the best so far. I'd also like to help you spread the word - I'm really surprised more people aren't excited about this tool. Good luck with the project.
Dean

Get Started

Log In Sign In