• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

Form/Subform Link

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
gcgcit
Asked:
gcgcit
  • 4
1 Solution
 
Rey Obrero (Capricorn1)Commented:
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
 
gcgcitAuthor Commented:
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
 
gcgcitAuthor Commented:
I think its in assigning the "Link Child Fields" and "Link Master Fields" where I'm messing up.  
0
 
gcgcitAuthor Commented:
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
 
gcgcitAuthor Commented:
Reviewed sample database myself and realized the relationship was incorrect on the query.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now