What is a Database Foreign Key?

[@cipher7565]

Thanks for stating how to determine where the foreign key goes. I've been trying to figure this out for so long now. It makes so much sense!

[@DatabaseStar]

Happy to help!

[@edenabreha8417]

Thank you this video is the best tutorial i have ever seen so far with a great explanation.Great Work!

[@DatabaseStar]

Thanks! I'm glad you like the video.

[@ronaldjohnson4470]

Thank you, I enjoyed the complete tutorial. Both parts were were helpful.

[@DatabaseStar]

Glad you liked it!

[@jessicajimmy5171]

kzbin.info/www/bejne/qIPQemRsftCkfZI

[@smitpatel1358]

Thanks Ben for your work! It’s an amazing tutorial!!

[@DatabaseStar]

Glad you like it!

[@ExcelTutorials1]

Very well explained, thank you!!

[@DatabaseStar]

Thanks, glad you like it!

[@Garrison86]

thank you so much! very helpful content, Cheers

[@DatabaseStar]

You're very welcome!

[@StevenTse]

what if an account have multiple customer (e.g. Subsidiary account )? how to achieve this?

[@DatabaseStar]

If an account has multiple customers, you can put the foreign key of the account in the customer table. You can check out my video on "one to many relationships" for an example of this: kzbin.info/www/bejne/amiyop-eoNiBf6M

[@name1927]

Nice video 👍🏻

[@DatabaseStar]

Thanks!

[@eulitamubaiwa9652]

Thank you for the explanation 👌👏👏

[@DatabaseStar]

Happy to help!

[@senju31]

Is it possible to insert information into the parent table and not into the child table?

[@DatabaseStar]

Yes you can do this, you can write an insert statement for the other table.

[@senju31]

@@DatabaseStar So there would be two insert statements?

[@senju31]

I ask because I was doing regular inserts into a table called contractors and it worked but then I tried to contractors to a new table and then tried to the insert into the same table (contractors) and it wouldn't. I want to be able to continue doing inserts into the original table.