Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 08-01-2010
Member
 
Join Date: May 2009
Posts: 320
Relationship among tables in access

What are the ways to create relationship among the tables of different database of the Microsoft Access 2007. I want to examine the relationship which is created between all the tables. There are around 5 tables related to employee record. What are the steps for the same. If I get an additional information of this it will be better.
Reply With Quote
  #2  
Old 08-01-2010
Member
 
Join Date: May 2008
Posts: 4,339
Re: Relationship among tables in access

Here are some possible solutions which help you to relate tables and different types of relationships that can exist between two tables in a database. If you do not know what a database connection, then better skip this and try to understand the basic concepts to understand the relationships.To create relationships in Access 2007 you must first access to the Relationships window we click the Relationships button located on the Tools tab in the database.It will display you option here. This is the starting point.
Reply With Quote
  #3  
Old 08-01-2010
Member
 
Join Date: May 2008
Posts: 4,829
Re: Relationship among tables in access

Like this you can make the relationship among tables in access. To create this the first relationship go to tools. Click on Show Table dialog box on the right waiting tables indicate that the relationship will be part of creating. Select one of the tables belonging to the link by clicking on it, that table will appear highlighted.Click on the Add button. Add up the databases here.
Reply With Quote
  #4  
Old 08-01-2010
Member
 
Join Date: Apr 2008
Posts: 4,086
Re: Relationship among tables in access

By adding table in the Table dialog box you can simply create relationship among all the tables. In the box go on the relationship field in the main table (in our case code). Press the left mouse button and holding until drag the field number of the child table . Release the mouse button after you finish the process.
__________________
Ram requirement for various OS
Reply With Quote
  #5  
Old 08-01-2010
Member
 
Join Date: Mar 2009
Posts: 1,585
Re: Relationship among tables in access

In the relationship box at the top should be the names of the two related tables (aulaClic_clientes and aulaClic_Facturas) and below them the names of the fields of relationship (code and number). Should always be fields that contain the same information and therefore the same type. At the bottom of the connection type to be assigned depending on the characteristics of the fields of relationship (in our case one of several).
Reply With Quote
  #6  
Old 08-01-2010
Member
 
Join Date: Jan 2008
Posts: 3,751
Re: Relationship among tables in access

Here are some more settings which can help you out for working on relationship. It is recommended that enable Enforce referential integrity box by clicking on it. If desired, the boxes can be activated surge Update Related Fields and surge Delete Related Records. Find out more about referential integrity and cascading operations. Finally, click on the Create button.This creates the relationship and it will appear in the Relationships window.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Relationship among tables in access"
Thread Thread Starter Forum Replies Last Post
How To use join relationship In Access 2003 Alfons Windows Software 3 04-02-2011 08:47 AM
Foreign key relationship among tables in SQL Satchel Software Development 4 06-01-2011 07:21 AM
Link two tables Using MS Access jean-paul martell Windows Software 3 03-10-2009 10:14 AM
SQL query between 2 tables linked by many to many relationship Luis234 Software Development 2 09-05-2009 02:17 PM
create tables in MS Access through VB6 Derek Software Development 2 11-10-2008 03:20 PM


All times are GMT +5.5. The time now is 05:08 AM.