Gudaha Microsoft Access , Xiriirku^{(Relationship)} wuxuu kaa caawinayaa inaad ku biirto ama ku xidho xogta hal miis oo kale. Cilaaqaadku^{(Relationships)} wuxuu u oggolaanayaa isticmaalaha inuu abuuro weydiimo, ^(Queries,) foomamka^(Forms) , iyo warbixinnada^(Reports) . Marka shax kasta loo sameeyo mawduuc kasta oo ku jira kaydka xogta, waa inaad gelisaa meelo la wadaago miiska la xidhiidha oo aad la samaysato xidhiidh si macluumaadka mar kale la isugu keeno.

Abuur^(Create) , Wax ka beddel^(Edit) , Tirtir^(Delete) Xiriirka Shaxda ee Helitaanka^(Access)

Waxaa jira saddex nooc oo Xiriir ah:

1. Xidhiidhka Mid-ka-Kaliya ^{(One-to-One Relationship)}: Xiriir^{(Relationship)} -ka-mid-ka-mid- ahaanshaha waa nooca ugu fudud ee xiriirka^{(Relationship)} waana kan ugu yar sababtoo ah macluumaadka la xiriira waxaa lagu kaydiyaa isla miis isku mid ah. Waxay ku xidhaysaa hal miis hal rikoodh oo miis kale ku yaal; Jadwalka isku xirka furayaasha aasaasiga ah. ^{(Primary Keys)}Hal-ka-mid-hal- xidhiddu^{(Relationship)} waxa ay ku xidhi kartaa miis ay ku jiraan goobo badan oo ay kala sooci karaan miis sababo ammaan dartood.
2. Xiriir Hal-ilaa-badan ah ^{(A One-to-Many relationship)}: Xiriir^{(Relationship)} -mid-ka-badan ayaa ah xiriirka^{(Relationship)} ugu badan ; waxay ku xidhaysaa diiwaan kasta oo hal miis ku yaal iyo dhawr diiwaan oo miis kale ku yaal. Kaliya mid ka mid ah goobaha la isku xiray ayaa noqon kara Furaha Aasaasiga ah^{(Primary Key)} , furaha koowaadna^{(Primary Key)} waa inuu lahaadaa hal diiwaan oo diiwaanno badan oo miis kale ah.
3. ^{(Many-to-Many relationships)}Xiriiro badan-ilaa-badan ^{(Relationship)}: Xiriir -badan-ilaa-badan ayaa u baahan Jadwal Isgoys ah^{(Junction Table)} , oo ay ku jiraan tiirka Furaha^{(Primary Key)} ee labada miis ee aad rabto inaad ku xirto. Xidhiidh^{(Relationship)} badan oo badan ayaa kuu ogolaanaya inaad ku xidho saf kasta oo hal miis ah safaf badan oo miis kale ah.

Waa maxay sababta loo isticmaalo xidhiidhada miiska ee Helitaanka?^{(Why use table relationships in Access?)}

• Xiriirka Shaxda ayaa cusbooneysiiya foomkaaga oo ka warbixinaya naqshadeynta^{(Table Relationships updates your form and report designs)} - Markaad naqshadeyso foom oo aad ka warbixiso, Xiriir^{(Relationship)} ayaa loo baahan yahay si loo^(Access) helo macluumaadka lagu dhejin karo foomka ama warbixinta aad abuurtay.
• Xidhiidhada Miiska waxay cusbooneysiiyaan naqshadaynta waydiimahaaga^{(Table Relationships updates your query design)} - Si diiwaanadu uga shaqeeyaan wax ka badan hal miis, waa in la abuuraa su'aal si loogu biiro jadwalkan. Weydiintu waxay ku shaqaysaa iyadoo la waafajinayo qiyamka ku yaal goobta muhiimka ah ee miiska kowaad iyo furaha ajnabiga ah ee shaxda labaad.
• Daacadnimada tixraaca waxa lagu xoojin karaa xidhiidhka miiska^{(Referential Integrity can be enforced in a table relationship)} - daacadnimada tixraaca^{(Referential Integrity)} waxay kaa caawinaysaa in laga hortago diiwaanada agoonta ee xogtaada. Diiwaanka agoonta waa diiwaanka tixraaca diiwaan kale oo aan jirin.

Maqaalkan, waxaan ku sharxi doonaa:

1. Sida Loo Abuuro Xidhiidhka^{(Relationship)} Helitaanka Microsoft^{(Microsoft Access)}
2. Sida Loo Tafatiro Xidhiidhka^{(Relationship)} Helitaanka Microsoft^{(Microsoft Access)}
3. Sida loo tirtiro xiriirka^{(Relationship)} ka dhexeeya Access Microsoft^{(Microsoft Access)}

1] Sida Loo Abuuro Xidhiidhka Helitaanka Microsoft^{(1] How to Create a Relationship in Microsoft Access)}

Tag Shaxda Shaxda^{(Table Tab)} ee ku taal bar menu-ka. Dooro Xiriirka^{(Relationship)} Daaqada xiriirka, dooro Shaxda ku dar. ^{(Add Table.)}Sanduuqa wada hadalka miiska ku dar ayaa furmi doona; guji Ku dar Shaxannada la xushay.^{(Add Selected Tables.)}

Dhinaca geeska bidix ee qaybta qalabka ee Xiriirka^{(Relationship)} , daaqada dhagsii Xiriirada Tafatirka. ^{(Edit Relationships.)}Dooro Abuur Cusub.^{(Create New.)}

Abuuritaanka sanduuq cusub oo wada-hadal ah, waxaad dooran doontaa Magaca Shaxda Bidix^{(Left Table Name)} iyo Magaca ^(Name)Jadwalka saxda^{(Right Table)} ah ee miiskaaga, ka dibna dooro Magaca Tusmada Bidix^{(Left Column Name)} iyo Magaca Tiirka Midig,^{(Right Column Name, )} kaas oo noqon doona Furaha koowaad^{(Primary Key)} ee miisaskaga; hadda guji OK.

Sanduuqa wada^{(Edit Relationship )} hadalka wax ka beddelka ayaa mar kale lagu arki doonaa doorashadaada; saxaafadda abuuro^(create) . Waxa kale oo jira door gaaban oo aad ka soo jiidi karto Furaha Koowaad^{(Primary Key)} hal miis oo kale; shax kasta oo ku xiran waa inuu la xiriiraa Furaha Koowaad^{(Primary Key)} . Tani waxay samayn doontaa xidhiidh ka dhexeeya labada miis.

2] Sida loo tafatiro cilaaqaadka gudaha Microsoft Access^{(2] How to edit relationships in Microsoft Access)}

Waxaad wax ka beddeli kartaa cilaaqaadkaaga^{(Relationships )} gelitaanka Microsoft^{(Microsoft Access)} ; Halkan waxaa ah dhowr tillaabo oo sidaas lagu sameeyo.

Laba jeer taabo khadka xiriirka ^{(Edit Relationship)},^{(Relationship Line)} oo sanduuqa wada hadalka wax ka beddelka ayaa soo muuqan doona.

Waxa jirta hab kale oo loo furo sanduuqa wada hadalka xidhiidhka wax ka beddelka. Tabaha Naqshadeynta^{(Design Tab)} , waxaad arki doontaa ikhtiyaarka Tafatirka Xiriirka ; ^{(Edit Relationship)}ku dhufo

Samee^(Make) isbedel kasta oo aad rabto inaad sameyso.

3] Tirtiridda Xidhiidhada Helitaanka Microsoft^{(3] Deleting Relationships in Microsoft Access)}

Si aad u tirtirto^(Delete) xidhiidhka ,^{(Relationship)} waa inaad ka saartaa laynka labada miis; kuwani waa cabbirada.

Midig ku dhufo cursorka, dhagsii Delete. Doorashada kale waa in la dhigo cursorka khadka ka dibna riix badhanka Delete Key Button^{(Delete Key Button)} .

Sanduuqa wada hadalka ayaa soo bixi doona oo ku weydiin doona 'haddii aad hubto inaad rabto inaad si joogto ah u tirtirto Xiriirka^{(Relationship)} .'

Guji OK _

Akhri wax la xidhiidha^{(Related read)} : Sida loo dhiso Miisaska Naqshadeeye Miiska ee Helitaanka^{(How to build Tables with Table Designer in Access)} .

Noogu soo sheeg faallooyinka haddii aad wax dhibaato ah kala kulanto waana kuu soo laaban doonaa.

How to Create, Edit and Delete a Table Relationship in Access

In Microsoft Access, a Relationship helps you to merge or link data from one table to another. Relationships allow the user to create Queries, Forms, and Reports. When tables are created for each topic in a database, you must place common fields into the table related and form a relationship with them for information to be brought together again.

Create, Edit, Delete a Table Relationship in Access

There are three types of Relationships:

1. One-to-One Relationship: One-to-One Relationship is the simplest kind of Relationship and the least common because the information related is stored in the same table. It links one table to a single record in another table; Primary Keys links tables. One- to- One Relationship can connect a table with many fields together and separate a table for security reasons.
2. A One-to-Many relationship: One-to-Many Relationship is the most common Relationship; it links each record in one table to several records in another table. Only one of the fields been linked can be the Primary Key, and the Primary Key must have one record for many records in another table.
3. Many-to-Many relationships: Many-to-Many Relationship requires a Junction Table, which includes the Primary Key column of the two tables you want to connect.  Many -to Many Relationship allows you to connect each row of one table to many rows in another table.

Why use table relationships in Access?

• Table Relationships updates your form and report designs – When you design a form and report, a Relationship is needed for Access to gather the information that can be placed in the form or report you have created.
• Table Relationships updates your query design – For records to work from more than one table, a query must be created to join these tables. The query works by matching the values in the first table’s primary key field with the foreign key in the second table.
• Referential Integrity can be enforced in a table relationship – Referential Integrity helps to prevent orphan records in your database. An orphan record is a record with reference to another record that does not exist.

In this article, we are going to explain:

1. How to Create a Relationship in Microsoft Access
2. How to Edit a Relationship in Microsoft Access
3. How to Delete a Relationship in Microsoft Access

1] How to Create a Relationship in Microsoft Access

Go to the Table Tab on the menu bar. Select Relationship In the relationship window, select Add Table. An add table dialog box will open; click on Add Selected Tables.

On the left corner in the tools section of the Relationship, window click on Edit Relationships. Select Create New.

In creating a new dialog box, you will choose the Left Table Name and the Right Table Name of your table, then choose the Left Column Name and Right Column Name, which should be the Primary Key of your tables; now click OK.

The Edit Relationship dialog box will be seen again with your selected choice; press create. There is also a shortcut option where you can drag the Primary Key from one table to another table; any table linked must be related to the Primary Key. This will form a relationship between the two tables.

2] How to edit relationships in Microsoft Access

You can modify your Relationships in Microsoft Access; here are a few steps in doing so.

Double-tap on the Relationship Line, and the Edit Relationship dialog box will show up.

There is another way of opening the edit relationship dialog box. On the Design Tab, you will see the Edit Relationship option; click on it.

Make whatever changes you want to make.

3] Deleting Relationships in Microsoft Access

To Delete a Relationship, you must remove the line from the two tables; these are the measures.

Right-click on the cursor, click Delete. The other option is to place the cursor on the line then press the Delete Key Button.

A dialog box will pop up asking you ‘if you are sure you want to permanently delete the Relationship.’

Click OK.

Related read: How to build Tables with Table Designer in Access.

Let us know in the comments if you have any problems and will get back to you.

Related posts

• MDB Viewer Plus: Arag oo wax ka beddel galka Xogta Xogta ee Microsoft

• Waa maxay Ctrl Alt Delete? Muxuu qabtaa Ctrl Alt Del? -

• Sida loo tirtiro dhibka & jid-gaabyada aan sax ahayn ee Guddiga Ciyaaraha

• Sida loo Abuuro, wax looga beddelo, oo loo tirtiro Tallaabooyinka Degdegga ah ee Muuqaalka

• Helitaanka Gudigga Kontoroolka NVIDIA waa la diiday - ma dabaqi doono dejinta

• Helitaanka degdega ah ma shaqaynayo ama ma yara in lagu furo Windows 11/10

• Habbee gelitaanka galka la xakameeyey adoo isticmaalaya Siyaasadda Kooxda & PowerShell

• Sida loo kabsado oo loo soo celiyo faylalka gelitaanka degdega ah gudaha Windows 11/10

• Sida Loo Sameeyo Goobo La Xisaabiyey ee Gelitaanka

• Hagaaji Gelitaanka Kontroolka Helitaanka waa qalad kharriban gudaha Windows 10

• Waa maxay Shabakadda Madow ama Shabakadda Deep? Sida loo galo & taxaddarrada.

• Gal Serverka FTP adoo isticmaalaya Command Prompt gudaha Windows 10

• Waa maxay Gelitaanka Fog ee Trojan? Kahortagga, Ogaanshaha & Ka saarida

• Fududeynta Helitaanka Beddelka: Ku beddel Fududeynta gelitaanka badhanka qalab waxtar leh

• Sida loo sameeyo Warbixin iyadoo la isticmaalayo Microsoft Access

• Adeegga Macmiilka ee DHCP waxa uu ku siinayaa cilad Helitaanka la diiday Windows 11/10

• Sida looga saaro badhanka fududaynta gelitaanka shaashada Logon

• Isticmaal Mashiinka Waqtiga Ogolaanshaha si aad meesha uga saarto Gelitaanka Faylka waa khaladaad la diiday

• HELIDDA LA DIIDAY - Waftiga xaddidan ee CIFS wuu guuldarraystay

• Gelitaanka waa la diiday, ma haysatid ogolaansho aad ku gasho serfarkan