Confused on Azure SQL Management Portal - Foreign Key
i have 2 tables accounts (account_id primary key, company_name, etc. etc.) invoices (inv_no primary key, account_id) i believe foreign key here account_id in invoices table as there many invoices same account_id accounts table. i trying set relationship in management portal, however, terminology , interface seems counter-intuitive me, , backwards. if select accounts table select indexes & keys, there button "add foreign key relationship". when click on button ask specify foreign key , shows check box next every field in accounts table select acccount_id, select reference table invoices, try select "reference column" , title shows "primary or unique keys', inv_no displayed. have in reverse and start invoices table select foreign key. me seems backwards , in dependency diagram arrow goes invoices accounts, seems backwards. missing? i know why management portal allows selection of multiple primary keys, thought disallowed in azure...