Link to home
Start Free TrialLog in
Avatar of gcgcit
gcgcit

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gcgcit
gcgcit

ASKER

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?
Avatar of gcgcit

ASKER

I think its in assigning the "Link Child Fields" and "Link Master Fields" where I'm messing up.  
Avatar of gcgcit

ASKER

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
Avatar of gcgcit

ASKER

Reviewed sample database myself and realized the relationship was incorrect on the query.