How to create relationships in Access 2010

A relationship between tables in an Access database, is a link enabling records within different tables to reference each other.
We can simplify our data recording and entry by creating separate tables and create relationships between these separate tables so that they can reference each other. This will reduce the amount of data stored, entered and minimise opportunities for data entry mistakes.
If you have any questions regarding this video please leave a comment.

[@AmaanNaidu]

thanks it was very helpful for my project

[@trippyadapt3710]

hi phil great video! i liked the way you made the use of media, such as audio , text and editing techniques the video was very enjoyable

[@hiyayoutube3702]

This was so helpful. Thank you

[@khakalijoy9020]

Thanks Phil you have helped me out

[@amritasarkar411]

Thank you so much for this video . Love' from India

[@terrellcampbell4852]

Great job I actually understand it

[@suzettewaugh]

thx ur a life saver

[@chitharanjanhegde8333]

Tq it was really helpful 😃

[@allamebrahtu8695]

Thanks really it help me

[@scarleyff]

Very helpful. Than you

[@noblemchibaya1494]

Thanks sir really helped a lot

[@jayeshwankhede8722]

Thanks a lot 😀

[@sirtoffchannel6378]

Tnx for sharing this info

[@suniljoy127]

Thank you 😊

[@ICTSolutionsWithTinsae]

useful tutor keep it up

[@agentsaigaming1272]

Very Useful sir

[@tootrue6529]

Hi Phil, great video! Thank you so much... One question though: When dragging the primary key from the "parent" table for the purpose of establishing the relationship between tables, does there already have to be an associated foreign key field in the "child" table to drop it on? Or is it possible to create a foreign key in the child table merely by dropping the primary key somewhere in the child table's box?

[@akmedia8206]

My question exactly

[@user-fu9yg4ir1c]

Thank you

[@khakalijoy9020]

Àaah what if you don't have same items in those tables how will you do it??

[@quintuckyy]

finals about to start in 1 hour. about to clutch this mf

[@madhuvaidya9257]

Thaaaaaaaaank youuuu

[@subhraprakashsantra9767]

How to make one 2 one relation

[@gulshanharode6679]

Relationship Ko hatana Hai To kaise hataye

[@darkkageamv4424]

Bruh he cannot speak/read hindi

[@nuhilibiz3794]

V 8