Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old September 29th, 2007, 08: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.


Reply With Quote
  #2 (permalink)  
Old October 1st, 2007, 07: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
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
master-detail hhpatek ADO.NET 0 April 3rd, 2008 03: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 01: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 05:16 AM



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


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