Creating a Relationship? (Having trouble)

[lpmndcte]

Hello everyone,

I created two tables, two forms, and created a relationship (which is probably not good) using 'joins' with a primary to primary key connection. However, I would like to do a primary to foreign key connection but I'm not sure how to do that with this complex type of database. I was not successful in uploading the file because its 1.82MB in size. I could only shrink in down to 700KB.


I designed a database and connect two tables to each other. I'm just unsure of how to build the relationship. I was able to build relationships in other databases but this was is very complex.

***TABLE ONE - DATA CAPTURE***
DATA CAPTURE ID (PRIMARY KEY)
TITLE
URL
COMMENTS: Brief rationale for inclusion (Drop Down with these categories)
OPERATIONAL AREA(S) ADDRESSED/IMPACTED -
FORCE HEALTH PROTECTION AND READINESS
CLINICAL EVALUATION AND TREATMENT
POLICY, ORGANIZATION, AND TREATMENT
RESEARCH AND INNOVATION
INTERNATIONAL HEALTH
BUSINESS TECHNOLOGY AND IT
OTHER (SPECIFY)
COVERED LAST WEEK


TONE - (Drop Down) POSITIVE, NEUTRAL, NEGATIVE
IMPACT - (Drop Down) HIGH, MODERATE, LOW
URLS OF RELATED LEADS
ATTACHMENTS

TABLE TWO - SYNTHESIS AND ANALYSIS
INFORMATION/ISSUE
COMMENT - MEMO
URL
COURSE OF ACTION
ATTACHMENTS
TONE - (Drop Down) POSITIVE, NEUTRAL, NEGATIVE
IMPACT - (Drop Down) HIGH, MODERATE, LOW

URGENT ACTION -(Drop Down with these items)
INQUIRIES
PRESS RELEASES
TALKING POINTS
ALERT SPEECHWRITER
MEDIA COACHING
EXISTING MEDIA INQUIRES


POTENTIAL AND ANTICIPATED INQUIRES
INFORMATION REPOSITORIES -
EXISTING KIR TOPIC
POTENTIAL KIR TOPIC
COMPS PLAN
DOD / MHS POLICY, GUIDANCE, ETC.

PERTINENT TO CURRENT / ONGOING TEAM EFFORTS - -(Drop Down with these items)

BLOG
SOCIAL MEDIA POSTS
HOLIDAY MESSAGING
HEALTH.MIL MICROSITE
WEBSITE CONSOLIDATION
CFO OUTREACH
WWR/WTU
OTHER

[lpmndcte]

NVM guys, I'm going through the video series to restudy concepts. I have missing gaps of fundamental info I need to brush up on.

[ssanfu]

Also read this http://access.mvps.org/access/tencommandments.htm

Especially #2, and follow the link about "Look up fields">> http://access.mvps.org/access/lookupfields.htm

[lpmndcte]

Thanks ssanfu.

I went through several videos and they were extremely helpful in determining the problem. I built and tested the database with two users and had many conflicted problems. After continued reading, I decided to split that database into the FE and BE and all the problems went away. I have the FE database on sharepoint. I'm going to present the solution during a meeting today.


Thanks for your assistance and thanks for this site having some good videos.