The Mudcat Café TM
Thread #47406   Message #706794
Posted By: Barbara Shaw
08-May-02 - 01:40 PM
Thread Name: tech: Access 97 Database: HELP!!!!!
Subject: RE: BS: Access 97 Database: HELP!!!!!
Hi Kim. Go into Access Query, Design View, and check the relationships between the three tables. You need to join them by using some field that exists in each, and you can do this by clicking on the field in one table and dragging it to the field in the other table. Then, you should double click on the line that is drawn between the two tables to see what kind of condition you actually set up. The "join properties" may be what prevents you from getting any records.