RE: setting up a foreign key

So, I'm told yes, I do but, no I don't...

From what I understand about foreign keys, is that the child table is where I need to put the foreign key.

So, I would add the foreign key on CustomerGroup. But, the only 2 columns I can choose from the parent table are CompanyID and Account#. I do not have the option to choose any other columns.

Yes, this is ALL new to me.



-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Justin Taylor
Sent: Wednesday, December 14, 2016 11:21 AM
To: Midrange Systems Technical Discussion
Subject: RE: setting up a foreign key

Yes, the parent table needs a key. In the "Parent table" frame (New Foreign Key Constraint wizard), select your table and the "Key columns" list will be populated with the available keys.



-----Original Message-----
From: Tammy Scott [mailto:tscott@xxxxxxxxxxxxxx]
Sent: Wednesday, December 14, 2016 10:15 AM
To: midrange-l@xxxxxxxxxxxx
Subject: setting up a foreign key

I am attempting to setup a foreign key using System I Navigator. I've never created a foreign key before.

Here is my question and I did my best to explain it. I am very new to all of this.

Customer table with columns.
CompanyID
Account#
Customergroup
Primary/unique key on customer table is CompanyID, Account#

CustomerGroup table with columns.
CompanyIDgrp
GroupID
GroupDescription
Primary/unique key on CustomerGroup table is CompanyIDgrp, GroupID

I need to setup a foreign key.

Does the Customer table need to have an index that has Customergroup as part of the key in order for me to setup a foreign key? I cannot figure out how to choose from the Customer Table, Customergroup.
Thanks for any help.
Tammy


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD