Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old September 29th, 2007, 07:06 AM
Authorized User
 
Join Date: Oct 2006
Location: Kolkata, West Bengal, India.
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.


  #2 (permalink)  
Old October 1st, 2007, 06:37 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
master-detail hhpatek ADO.NET 0 April 3rd, 2008 02:53 PM
Master Detail Records Amsterdaz ASP.NET 2.0 Basics 4 November 10th, 2007 10:58 AM
Need Help Master Detail page ollie281 Dreamweaver (all versions) 0 August 7th, 2006 12:35 PM
master/detail beeyule Dreamweaver (all versions) 1 January 18th, 2005 02:59 AM
detail-master pages katie456 Classic ASP Databases 1 June 13th, 2003 04:16 AM





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