Helpful. How to assign field key a foreign key

J23

Senior Member
Nov 11, 2016
122
130
Habari zenu wana JF.
Jamani mimi nipo kwenye course ya kujifunza computer. Naomba msaada.
How to assign/ create a field key in first table to be a foreign key in second table so as can lead to create one to many relationship in access 2017.
Huwa nikitengeneza one to many relationship ile symbol au joining line ya kuonyesha nime create one to may relationship haitokei na huwa inakuja line inayoonyesha one to one relationship. Naomba msaada kwa hili wakuu.
Pia on query. If two tables or one table is created then on specifying the field to retrieve with its records using query design, I got multiple records when running a query.
So how you can prevent multiple records to occur more than once?
Thanks in advance
 
swali zuli mkuu nami nasubilia majibu alafu nitaku PM tuzungumze coz nami nipo kwa process kutengeneza database stysteam.
 
Back
Top Bottom