Solved

relationship records look up table

Posted on 2013-02-06
3
369 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
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 250 total points
ID: 38862556
0
 
LVL 52

Assisted Solution

by:Scott Fell, EE MVE
Scott Fell,  EE MVE earned 250 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…

809 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