J23
Senior Member
- Nov 11, 2016
- 151
- 193
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
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
