tadim
|
| Posted: 01/13/2003, 4:39 AM |
|
Hi,
I have an access database with two tables. Both tables have one field (e.g.labname) which is the same in both tables. I want to create one link in the master table which will link to detail table and gives only the results with the same labname.
Pls help me
|
|
|
 |
David Crandall
|
| Posted: 01/13/2003, 5:06 AM |
|
If you're using Studio, select ... box in List Data Source, then "Build Query", then add all the tables you wish to link. Create relational line by dragging one of the table fields to the other tables matching field. Click "OK" and using the "+" add the "where" statement. Save and return to design view to create the additional fields in the results Grid view.
|
|
|
|
|
