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 03-10-2009
Member
 
Join Date: Mar 2009
Posts: 92
Link two tables Using MS Access

I made a database in access 2007. It contains information and photographs and I linked that to my other database. (They all displayed well in the Main bd.) How do i interlink two tables in ACCESS 2007.Thank you for your help
Reply With Quote
  #2  
Old 03-10-2009
Member
 
Join Date: May 2008
Posts: 4,829
Re: Link two tables Using MS Access

To interlink between two tables you need to specify relationship. In a relational database, relationships enable you to prevent redundant data.When you create a relationship between tables, the related fields do not have to have the same names.
Reply With Quote
  #3  
Old 03-10-2009
Member
 
Join Date: Dec 2008
Posts: 371
Re: Link two tables Using MS Access

You need one field unique field (where the value is unique) in both table so that they can be linked together. You can create an empty database and you import your data of two tables and for all main tables under option you choose.This way I can see the structure without the data. For example you can use IDNUM as your primary key in both tables and link the tables using that field.
Reply With Quote
  #4  
Old 03-10-2009
Member
 
Join Date: May 2008
Posts: 4,339
Re: Link two tables Using MS Access

For example : try this query UNION formula:
SELECT No Customer Subscriber
FROM [T1_database] UNION ALL SELECT No Customer Subscriber
FROM [T2_database];
Check that the names [No. Customer Subscriber] correspond to your tables!
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Link two tables Using MS Access"
Thread Thread Starter Forum Replies Last Post
How to Link Excel Tables with each other Iyyappan MS Office Support 2 23-02-2012 05:57 PM
How to Link two separate Excel Tables Shaina Na Windows Software 1 07-01-2012 08:16 PM
Relationship among tables in access Bindusar Windows Software 5 08-01-2010 05:47 AM
SQL querry to join 2 tables from access dB Aanand Software Development 3 09-05-2009 05:15 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 06:31 PM.