?
Solved

relationship records look up table

Posted on 2013-02-06
3
Medium Priority
?
387 Views
Last Modified: 2013-02-11
hey guys, i can't remember how to do this exactly and can't think of the keywords to find it on google, but Access has this feature where if two tables are joined through relationships, when you open one table and select one record, it will show you all the other records from the other table that are linked.

how do i enable this feature? thanks guys!!
0
Comment
Question by:developingprogrammer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 1000 total points
ID: 38862556
0
 
LVL 53

Assisted Solution

by:Scott Fell, EE MVE
Scott Fell,  EE MVE earned 1000 total points
ID: 38862656
If you create a one to many relationship such as contacts and purchases.  One contact has many purchases.  

Contacts:
ID
Name

Purchases:
ID
Contact_ID
Item_ID
Qty
Price

You would link Contacts.ID to Purchases.Contact_ID with a one to many relationship where contacts are the one and purchases are the many.
http://office.microsoft.com/en-us/access-help/guide-to-table-relationships-HA010120534.aspx
0
 

Author Closing Comment

by:developingprogrammer
ID: 38876038
cool! great guys! thank you!! = ))
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question