Relationships between two tables sgtschultz1981 04.08.2006 15:24:01 I have two tables created and I have a one to many relationship on them. The table I am using in my report has two foreing keys to draw information from two places in the other table. Why is it that when I view the report it just shows the autonuumber i used to call it with? What do I need to do to get the information in the report instead of the number used to import the information. Example: Table 1 is LSV-2472 with fields LSV-2472-Autonumber Serial Number-text Delta Q1-number Delta Q2-number Table 2 is Delta Q with fields Delta Q-Autonumber Serial Number-text The relationship is between Delta Q1 and Delta Q2 on the LSV-2472 table, both of these connect to Delta Q on the Delta Q table. I put the autonumber in the Delta Q1 and Delta Q2, using them as foreign keys. What I want in my report is the serial numbers from the Delta Q table not the autonumbers, How do I do this?

Re: Relationships between two tables John Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 04.08.2006 17:53:15 On Fri, 4 Aug 2006 08:24:01 -0700, sgtschultz1981 <sgtschultz1981[ at ]discussions.microsoft.com> wrote: [Quoted Text] >I have two tables created and I have a one to many relationship on them. The >table I am using in my report has two foreing keys to draw information from >two places in the other table. Why is it that when I view the report it just >shows the autonuumber i used to call it with? What do I need to do to get the >information in the report instead of the number used to import the >information. Base the report on a QUery joining the two tables. The foreign key is just that - a link to the other table. It doesn't contain the data from the other table! John W. Vinson[MVP]