Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MS Access 2007: How toi create a connector line that represents one-to-many (optional/compulsory) relationships?

Posted on 2007-03-23
4
Medium Priority
?
361 Views
Last Modified: 2012-08-13
HI experts:

I am using MS Access 2007 to create a relationship between tables.

I would like to learn how to create a connector line which represents one-to-many (optional or compulsory) relationships.

Thanks a lot!

duta

0
Comment
Question by:duta
[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
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1200 total points
ID: 18783445
Drag the Primary Key field from the 'one' table to the related (Foreign Key) field in the Many table.  The Relationships dialog will appear.  Check 'Enforce Referential Integrity'.  Check Cascade Updates and/or Deletes as appropriate per the 'business rules' of your application.

That's it ...

mx
0
 
LVL 75
ID: 18783455
Actually ... First - Open the Relationships Window.  Then, drag the tables of interest onto that Window from the Database window/container ... Or ... right click over the Rel window ... and select Show Table ...   and pick you tables.

mx
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 800 total points
ID: 18783469
0
 

Author Comment

by:duta
ID: 18783655
Dear experts:

Thank you so much for your kind, prompt response.

I will check all of your tips and come back to you soon!

By the way, I posted one more question regarding how to bend dynamic connector in MS Visio 2003.

Hope you may kindly help me with that too!

duta
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

636 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