p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access VBA (http://p2p.wrox.com/forumdisplay.php?f=80)
-   -   Master Detail (http://p2p.wrox.com/showthread.php?t=62447)

prasanta2expert September 29th, 2007 07:06 AM

Master Detail
 
Hello Frnds,

Can you please help me regarding the following problem?

I am having one .mdb file, which contains only tables and queries, and another .mdb file, which contains only forms.

Also I have two tables with one-to-many relationship.

Student
=======
StudentID
StudentName

Marks
==========
StudentID
Subject
Marks

Now I need one master-detail form in which master form will be student details and detail form will be their marks detail.

Please help me.



mmcdonal October 1st, 2007 06:37 AM

I am assuming that the tables in one file are linked to the other file. If so, make sure the relationship between the Student and Marks tables is indicated in the relationship view with enforce referential integrity checked, then click once on the student table, then click the auto-form button. This will create the form / subform that you want.

Did that help?


mmcdonal


All times are GMT -4. The time now is 06:18 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.