Access - Working with Subforms and making Relationships work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am building a database with a Subform. I am trying to build a Relationship
with the Form and the Subform. I am having trouble getting the Subform to
retrieve information form the Main Form . For example:

The Main Form will track companies profiles and the Subform will track the
company employees. I am trying to get the Main Form to pull up the company of
the employee for the Subform every time someone enters the company name in a
Field on the Subform.

For some reason I can't remember how to do this. I thought building a
relationship would work, but it's not.
 
Areyou going to type data in the subform to display data in the Main form?
Then the subform s/b the main form - the main form s/b the subform.

When you insert the subform in the main form the wizard will give you option
of how they are going to be related or you can set up your own, I beiliev you
will have to set teh company name field as the link
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top