• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

SQL key question

Foreign keys do not require mapping to unique indices or primary keys. If they did we'd be screwed on n:m mappings, forcing the database to do a brute-force lookup in the intermediary table with no help from an index.
 
why then when i create an a record in a table that has two foreign keys, it doesent allow it unless i have values for the foreign key fields that realte to each of the other tables?
 
Aside from a DBMS-specific issue, you probably also might have a unique index on one of those fields, a PK restriction, or a non-null restriction on a field. There's a lot of stuff these things hide behind GUIs and -isms.
 
You must log in or register to reply here.
Back
Top