Solved

Access 2007 - Design of main form to sub form linkage

Posted on 2013-11-20
3
663 Views
Last Modified: 2013-11-23
My OS is win 7 prof 64 bit and I use office 2007.  I am trying to create a simple book distribution database for my non-profit org and am stuck on the relationship linkages.  I attach herewith a Word 2007 document on the design that I have so far and also the Access 2007 file that I created to begin the project.   My present problem is the set up of the main form and the imbedded sub form.  Hope the experts can please take a look and let me know what I am doing wrong or how to correct it, and it will be wonderful if I can have the corrected access file.   once I get the initial glitches over and done with, then I can move on slowly but surely implementing one item at a time. Thank u.
Book-Distribution.accdb
Design-of-a-book-distribution-da.docx
0
Comment
Question by:jegajothy
  • 2
3 Comments
 
LVL 30

Accepted Solution

by:
hnasr earned 500 total points
ID: 39663291
Issue is not clear.

Think of the main form and subform as a sheet of paper with 2 portions.
The top 1 holds say a father name with fatherID, fatherName, ...
The second portion holds a list of children in rows.
fatherID, childID, childName, ...

The main form is linked to subform through fatherID as master fields and child fields.
0
 

Author Closing Comment

by:jegajothy
ID: 39671894
thank u.
0
 
LVL 30

Expert Comment

by:hnasr
ID: 39672087
Welcome!
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question