?
Solved

Form/Subform Link

Posted on 2011-03-11
5
Medium Priority
?
271 Views
Last Modified: 2013-11-05
The form and subform are not linking.  

See data model and sample database for object relationship.

I want employees to show up on main table and their associated paces on the subform.

In sample database I gave first example actual links in data but it's not displaying on the forms.
ee-pacedatamodel.jpeg
ee-Pace.mdb
0
Comment
Question by:gcgcit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 1500 total points
ID: 35112067
follow the instructions from here

Create a form that contains a subform (a one-to-many form)
http://office.microsoft.com/en-us/access-help/create-a-form-that-contains-a-subform-a-one-to-many-form-HA010098674.aspx?CTT=3
0
 

Author Comment

by:gcgcit
ID: 35112111
I tried to follow that but I don't know what I'm missing.  I supplied a sample database, could you take a quick look?
0
 

Author Comment

by:gcgcit
ID: 35112135
I think its in assigning the "Link Child Fields" and "Link Master Fields" where I'm messing up.  
0
 

Author Comment

by:gcgcit
ID: 35112290
My scenario is slightly different than the link previded because I have a junction table between the two tables to eliminated my many-to-many relationship
0
 

Author Closing Comment

by:gcgcit
ID: 35112402
Reviewed sample database myself and realized the relationship was incorrect on the query.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

770 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