If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
relationships
I have set up a database with Two Tables. I have created one of the tables
and have inported a table from another exsisting database. I have set up a one-to-many relationship but now I am not sure what to do to make the information link to the new table. |
#2
|
|||
|
|||
relationships
On Thu, 9 Mar 2006 13:49:26 -0800, Melissa
wrote: I have set up a database with Two Tables. I have created one of the tables and have inported a table from another exsisting database. I have set up a one-to-many relationship but now I am not sure what to do to make the information link to the new table. What do you expect to see? If you create a Query and add both tables, Access should automatically join the two tables on the linking field that you have defined. You can then open this Query (or, better, base a Form or Report on the query) and see all of the fields from both tables. If you have multiple matching fields in both tables and you're expecting the data to automagically fill itself in to both tables, you're misunderstanding relationships (this is a very common error for folks getting started with Access, or I wouldn't raise the question!) John W. Vinson[MVP] |
#3
|
|||
|
|||
relationships
The primary key in one table should match a field in another table and then
you get the one to many relationship. "Melissa" wrote: I have set up a database with Two Tables. I have created one of the tables and have inported a table from another exsisting database. I have set up a one-to-many relationship but now I am not sure what to do to make the information link to the new table. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Moving Relationships Between Databases | kh | Running & Setting Up Queries | 4 | February 23rd, 2006 05:46 PM |
Using Relationships window | [email protected] | Database Design | 11 | October 2nd, 2005 06:44 PM |
Confused about one-to-many or many-to-many relationships | CAD Fiend | Database Design | 4 | July 7th, 2005 03:38 PM |
Importing Tables/Missing Relationships | Elena | Running & Setting Up Queries | 1 | May 20th, 2005 12:43 AM |
Mixed up with Relationships..help! | KrazyRed | New Users | 3 | January 26th, 2005 05:03 AM |