Question: how can I Establish Relationship(s) and Enforce Referential Integrity between these two tables Sarah Hammadi O ALC ab X ES Table Tools Sarah Project: Database-Userssh

how can I Establish Relationship(s) and Enforce Referential Integrity between these two tables how can I Establish Relationship(s) and Enforcehow can I Establish Relationship(s) and Enforcehow can I Establish Relationship(s) and Enforcehow can I Establish Relationship(s) and Enforce

Sarah Hammadi O ALC ab X ES Table Tools Sarah Project: Database-Userssh 1492\Documents\Sarah Project.accdb (Access 2007-2016 file format) - Access File Home Create External Data Database Tools Help Fields Table Tell me what you want to do of Cut 21 Ascending Y Selection New Totals ac Replace s Calibri (Detail) - 11 Be Copy Al Descending Advanced Save Spelling Go To View Paste Filter Refresh Find BI U A === Format Painter 9 Select Remove Sort 7 Toggle Filter All X Delete More Views Clipboard Sort & Filter Records Find Text Formatting All Access Obje... Relationships 3 PROJECTS 3 Simple project PROJECT_CC - PROJECT_M - MANAGER_F - MANAGER_/ - PROJECT_BII - Click to Add- Search P 21-52 Tables Holly B.Parker 904-338-3416 3334 Lee Rd., G 16,833,460.00 25-2D Jane D. Grant 615-898-9909 218 Clark Blyd., 12,500,000.00 2 PROJECTS 25-5A George F. Dort: 615-227-1245 124 River Dr., F 132,512,420.00 2 Simple project 25-9T Holly B.Parker 904-338-3416 3334 Lee Rd., G21,563,234.00 27.40 George F. Dort: 615-227-1245 124 Fiver Dr, Fr 110,314,545.00 29-2D Holly B.Parker 904-338-3416 3334 Lee Rd, G. 25,559,999.00 31-7P William K.Moo 904-445-2719 216 Morton Rd. 56,850,000.00 $0.00 Record: K+B of 8 No Filter Search 8 Datasheet View Num Lock Type here to search 0 gi AL -08) 9:29 PM 3/2/2022 o Sarah Hammadi AL Find X ES Table Tools Sarah Project: Database-C\Users\sh 1482\Documents\Sarah Project.accdb (Access 2007 - 2016 file format) - Access File Home Create External Data Database Tools Help Fields Table Tell me what you want to do of Cut 21 Ascending Selection New Totals s ac Replace Calibri (Detail) Be Copy A1 Al Descending Advanced - Save Spelling Go To View Paste Filter Refresh BIU A ab Format Painter Select 4 Remove Sort Toggle Filter All X Delete More , Views Clipboard Sort & Filter Records Find Text Formatting All Access Obje... Relationships 2 PROJECTS 3 Simple project PROJ_NUM - PROPNAME - EMP_NUM - EMP_NAME - OB_CODE - JOB CHG_HC - PROJ_HOUR - EMP_PHONE - Click to Add- - - - - Search P 3 Satelite Tables 85 19,8 123 Mary D. Chen EE 615-233-5432 1 Hurricane 110 Anne R. Ramor CT 62 14,3 615-233-5568 2 PROJECTS 3 Satellite 110 Anne R. Ramor CT 62 11.6 615-233-5568 2 Simple project 3 3 Satellite 112 Allecia R. Smith BE 95 20.7 615-678-6879 1 Hurricane 105 David F. Schwa CT 62 16.2 653-234-1123 3 Satellite 105 David F. Schwa CT 62 23.4 653-234-1123 1 Hurricane 101 John D. Newso EE 85 13.3 653-234-3245 2 Coast 101 John D. Newso EE 85 19.8 653-234-3254 2 Coast 108 June H. Sattlen EE 85 17.5 905-554-7812 0 0 0 0 0 * Record: 11 of 11 No Filter Search Datasheet View Num Lock IE 9:29 PM -08) 3/2/2022 Type here to search O 0 8 LAB o Sarah Hammadi New a Copy X ES Relationship Tools Sarah Project: Database-C:\Users sh1482 Documents\Sarah Project.accdb (Access 2007 - 2016 file format) - Access File Home Create External Data Database Tools Help Design Tell me what you want to do of cut 21 Ascending 7 Selection Total ac Replace > 11 Descending Advanced Save Spelling Go To View Paste Filter Refresh Find Format Painter Remove Sort y Toggle Filter BIU A... zz 4. All X Delete More - Select Views Clipboard E Sort & Filter Records Find Text Formatting Relationships PROJECTS Simple project All Access Obje... Search PROJECTS Simple project Tables 2 Y ID Y PROJECT CODE 2 PROJECTS PROJECT MANAGER PROJ_NUM Simple project PROJNAME MANAGER PHONE EMP NUM MANAGER ADRESS EMP NAME PROJECT_BID PRICE OB CODE JOB CHG_HOU PROJ_HOURS EMP PHONE Ready Num Lock 1 Type here to search LAB 9:29 PM 3/2/2022 O Sarah Hammadi Total a Copy X ES Relationship Tools Sarah Project : Database-C:\Users\sh1482 Documents\Sarah Project.accdb (Access 2007 - 2016 file format) - Access File Home Create External Data Database Tools Help Design Tell me what you want to do of cut 21 Ascending Selection New ac Replace - > 11 Descending Advanced Save Spelling Go To View Paste Filter Refresh Find Format Painter Remove Sort y Toggle Filter BIU A aty. Ez 4. B. X Delete - More All Select Views Clipboard Sort & Filter Find Records Text Formatting Relationships All Access Obje... Search PROJECTS Edit Relationships ? Tables 2 7 ID 2 PROJECTS Table/Query: Related Table Query: PROJ_NUM Create 2 Simple project PROJNAME Simple project PROJECTS Canoel EMP_NUM JECT CODE OB_CODE EMP NAME Join Type OB CODE JOB CHG_HOU Create New.. Enforce Referential integrity PROI_HOURS EMP PH Microsoft Access X Microsoft Access can't create this relationship and enforce referential integrity. Data in the table PROJECTS violates referential integrity rules i , For example, there may be records relating to an employee in the related table, but no record for the employee in the primary table. Edit the data so that records in the primary table exist for all related records if you want to create the relationship without following the rules of referentiategrity, clear the Enforce Referential Integrity check box. OK Creating relationship... Type here to search LAB - H.] (2) Num Lock 9:32 PM 3/2/2022

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!